DBA Data[Home] [Help]

APPS.BOMPIINQ dependencies on FND_PROFILE

Line 111: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')

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
111: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
112: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')
113: AND msi.INVENTORY_ITEM_ID = item_id
114: AND child_org.ORGANIZATION_ID = org_id
115: )

Line 112: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')

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
111: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
112: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')
113: AND msi.INVENTORY_ITEM_ID = item_id
114: AND child_org.ORGANIZATION_ID = org_id
115: )
116: LOOP