Page 1 of 1
MULTI ORG DATA REPORT
Posted: Tue Jul 29, 2008 4:27 am
by wenjie
CAN SOME ONE GIVE ME A EXAMPLE HOW GO GET MULTI ORG DATA FROM
ar_misc_cash_distributions_v
IF I'M MY LOGIN ORG ID IS '102', HOW CAN I GET DATA FROM '104' DATA
Posted: Wed Jul 30, 2008 5:46 am
by hiszaki
Hi wenjie
If you use TOAD tools to get the data from this view "ar_misc_cash_distributions_v" then you can run this program before read the data.
begin
fnd_client_info.set_org_context(:P_ORG_ID);
end;
by change the parameter P_ORG_ID from 102 to 104.
Be carful the view only read the data according to the ORG_ID in the application & if you want to read all data you can get it from the table:
AR_MISC_CASH_DISTRIBUTIONS_ALL
Thanks
Hisham
Posted: Tue Aug 05, 2008 1:21 am
by wenjie
thx, now i can get all data from AR_MISC_CASH_DISTRIBUTIONS_ALL
[:)]