MULTI ORG DATA REPORT

[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

[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

[wenjie]

thx, now i can get all data from AR_MISC_CASH_DISTRIBUTIONS_ALL

[:)]