1321: orgs.ORGANIZATION_ID
1322: FROM
1323: ORG_ACCESS_VIEW oav,
1324: MTL_SYSTEM_ITEMS_B msi,
1325: MTL_PARAMETERS orgs,
1326: MTL_PARAMETERS child_org
1327: WHERE
1328: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
1329: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
1322: FROM
1323: ORG_ACCESS_VIEW oav,
1324: MTL_SYSTEM_ITEMS_B msi,
1325: MTL_PARAMETERS orgs,
1326: MTL_PARAMETERS child_org
1327: WHERE
1328: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
1329: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
1330: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID