eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on FND_PROFILE

Line 251: AND asa.org_id = fnd_profile.value('ORG_ID')

247: UPDATE ego_item_associations_intf eiai
248: SET supplier_site_name = ( SELECT vendor_site_code
249: FROM ap_supplier_sites_all asa
250: WHERE asa.vendor_site_id = eiai.pk2_value
251: AND asa.org_id = fnd_profile.value('ORG_ID')
252: )
253: WHERE eiai.batch_id = p_batch_id
254: AND eiai.process_flag = G_REC_IN_PROCESS
255: AND eiai.supplier_site_name IS NULL

Line 367: AND assa.org_id = fnd_profile.value('ORG_ID')

363: FROM ap_supplier_sites_all assa
364: WHERE assa.vendor_site_id = eiai.pk2_value
365: --AND assa.vendor_id = eiai.vendor_id
366: AND assa.vendor_id = eiai.pk1_value
367: AND assa.org_id = fnd_profile.value('ORG_ID')
368: )
369: );
370: UPDATE ego_item_associations_intf eiai
371: SET process_flag = G_REC_ASSOCIATION_NOT_EXISTS

Line 587: AND oav.responsibility_id = FND_PROFILE.Value('RESP_ID')

583: (
584: SELECT 1
585: FROM org_access_view oav
586: WHERE oav.organization_id = eiai.organization_id
587: AND oav.responsibility_id = FND_PROFILE.Value('RESP_ID')
588: AND oav.resp_application_id = FND_PROFILE.Value('RESP_APPL_ID')
589: );
590: UPDATE ego_item_associations_intf eiai
591: SET process_flag = G_REC_ALREADY_ASSIGNED

Line 588: AND oav.resp_application_id = FND_PROFILE.Value('RESP_APPL_ID')

584: SELECT 1
585: FROM org_access_view oav
586: WHERE oav.organization_id = eiai.organization_id
587: AND oav.responsibility_id = FND_PROFILE.Value('RESP_ID')
588: AND oav.resp_application_id = FND_PROFILE.Value('RESP_APPL_ID')
589: );
590: UPDATE ego_item_associations_intf eiai
591: SET process_flag = G_REC_ALREADY_ASSIGNED
592: WHERE eiai.batch_id = p_batch_id

Line 617: AND assa.org_id = fnd_profile.value('ORG_ID')

613: (
614: SELECT 1
615: FROM ap_supplier_sites_all assa
616: WHERE assa.vendor_id = eiai.pk1_value
617: AND assa.org_id = fnd_profile.value('ORG_ID')
618: );
619: UPDATE ego_item_associations_intf eiai
620: SET process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG
621: WHERE eiai.batch_id = p_batch_id

Line 1647: AND asa.org_id = fnd_profile.value('ORG_ID')

1643: FROM ap_suppliers aas, ap_supplier_sites_all asa
1644: WHERE aas.vendor_id = asa.vendor_id
1645: AND asa.vendor_site_code = eiai.supplier_site_name
1646: AND asa.vendor_id = eiai.pk1_value -- BUG 6322084
1647: AND asa.org_id = fnd_profile.value('ORG_ID')
1648: )
1649: , -1)
1650: WHERE eiai.batch_id = p_batch_id
1651: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)