DBA Data[Home] [Help]

APPS.BOMPIINQ dependencies on ORG_ACCESS_VIEW

Line 106: FROM ORG_ACCESS_VIEW oav, MTL_SYSTEM_ITEMS_B msi,

102:
103: elsif ( organization_option = 3 ) then
104: /* Bug:4929268 Performance Fix */
105: for C1 in ( SELECT orgs.ORGANIZATION_ID
106: FROM ORG_ACCESS_VIEW oav, MTL_SYSTEM_ITEMS_B msi,
107: MTL_PARAMETERS orgs, MTL_PARAMETERS child_org
108: WHERE orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
109: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
110: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID