How to find master org information in Oracle RDF reports?

Oracle Apps Interview Questions › Category: RDF Reports › How to find master org information in Oracle RDF reports?
0 Vote Up Vote Down
Questions Master asked 9 years ago

Is there any other way other than writing an sql query with multiple tables?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 9 years ago

To find master org we use oracle seeded oe_sys_parameters API
 
Example:-

nvl(oe_sys_parameters.value(‘MASTER_ORGANIZATION_ID’,mo_global.get_current_org_id()),0)