SELECT ORGANIZATION_ID BIS_ORG_ID FROM ORG_ACCESS WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID UNION ALL SELECT ORG.ORGANIZATION_ID BIS_ORG_ID FROM mtl_parameters org WHERE NOT EXISTS ( select '1' from org_access ora where org.organization_id = ora.organization_id)
SELECT ORGANIZATION_ID BIS_ORG_ID
FROM ORG_ACCESS
WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID UNION ALL SELECT ORG.ORGANIZATION_ID BIS_ORG_ID
FROM MTL_PARAMETERS ORG
WHERE NOT EXISTS ( SELECT '1'
FROM ORG_ACCESS ORA
WHERE ORG.ORGANIZATION_ID = ORA.ORGANIZATION_ID)
|
|
|