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.

[Home] [Help]

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 369: AND assa.org_id = fnd_profile.value('ORG_ID')

365: WHERE assa.vendor_site_id = eiai.pk2_value
366: --AND assa.vendor_id = eiai.vendor_id
367: AND assa.vendor_id = eiai.pk1_value
368: AND nvl(assa.inactive_date,SYSDATE + 1)>SYSDATE --BUG 11072046
369: AND assa.org_id = fnd_profile.value('ORG_ID')
370: )
371: );
372: UPDATE ego_item_associations_intf eiai
373: SET process_flag = G_REC_ASSOCIATION_NOT_EXISTS

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

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

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

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

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

615: (
616: SELECT 1
617: FROM ap_supplier_sites_all assa
618: WHERE assa.vendor_id = eiai.pk1_value
619: AND assa.org_id = fnd_profile.value('ORG_ID')
620: AND nvl(assa.inactive_date,SYSDATE + 1)>SYSDATE --BUG11072046
621: );
622: UPDATE ego_item_associations_intf eiai
623: SET process_flag = G_REC_ASSOC_ITEM_NOT_IN_ORG

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

1709: FROM ap_suppliers aas, ap_supplier_sites_all asa
1710: WHERE aas.vendor_id = asa.vendor_id
1711: AND asa.vendor_site_code = eiai.supplier_site_name
1712: AND asa.vendor_id = eiai.pk1_value -- BUG 6322084
1713: AND asa.org_id = fnd_profile.value('ORG_ID')
1714: AND nvl(asa.inactive_date,SYSDATE + 1)>SYSDATE --BUG11072046
1715: )
1716: , -1)
1717: WHERE eiai.batch_id = p_batch_id