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.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 226: -- bug 7430783 Changing validation table to ap_supplier_sites_all

222:
223: IF x_org_id is NOT NULL THEN
224: SELECT count(*)
225: INTO l_dup_count_org_id
226: -- bug 7430783 Changing validation table to ap_supplier_sites_all
227: --FROM po_vendor_sites_all SITE
228: FROM ap_supplier_sites_all SITE
229: WHERE SITE.vendor_id = x_vendor_id
230: AND SITE.org_id = x_org_id

Line 228: FROM ap_supplier_sites_all SITE

224: SELECT count(*)
225: INTO l_dup_count_org_id
226: -- bug 7430783 Changing validation table to ap_supplier_sites_all
227: --FROM po_vendor_sites_all SITE
228: FROM ap_supplier_sites_all SITE
229: WHERE SITE.vendor_id = x_vendor_id
230: AND SITE.org_id = x_org_id
231: AND UPPER(SITE.vendor_site_code) = UPPER(x_vendor_site_code);
232:

Line 236: -- bug 7430783 Changing validation table to ap_supplier_sites_all

232:
233: ELSIF (x_org_id is NULL and x_org_name is NOT NULL) THEN
234: SELECT count(*)
235: INTO l_dup_count_org_name
236: -- bug 7430783 Changing validation table to ap_supplier_sites_all
237: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG
238: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG
239: WHERE SITE.vendor_id = x_vendor_id
240: AND ORG.name = x_org_name

Line 238: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG

234: SELECT count(*)
235: INTO l_dup_count_org_name
236: -- bug 7430783 Changing validation table to ap_supplier_sites_all
237: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG
238: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG
239: WHERE SITE.vendor_id = x_vendor_id
240: AND ORG.name = x_org_name
241: AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)
242: AND SITE.org_id = ORG.organization_id;

Line 2734: for the same party. We can link the ap_supplier_sites_all table

2730: BEGIN
2731: /*If party_site_id is null then we derive it based on the
2732: party_site_name field provided. But in case of Upgraded records there
2733: can be multiple records in hz_party_sites with same party_site_name
2734: for the same party. We can link the ap_supplier_sites_all table
2735: to get unique record based on the input info*/
2736:
2737: if(p_party_site_id is not null) then
2738: SELECT hzps.party_site_name, hzps.party_site_id

Line 2747: FROM hz_party_sites hzps, ap_supplier_sites_all aps

2743: AND aps.vendor_id = p_vendor_id;
2744: else
2745: SELECT hzps.party_site_name, hzps.party_site_id
2746: INTO l_party_site_name,p_party_site_id
2747: FROM hz_party_sites hzps, ap_supplier_sites_all aps
2748: WHERE aps.org_id = p_org_id
2749: AND hzps.party_site_name = p_party_site_name
2750: AND hzps.party_site_id = aps.party_site_id
2751: AND aps.vendor_id = p_vendor_id;

Line 2770: FROM hz_party_sites hzps, ap_supplier_sites_all aps,

2766:
2767: BEGIN
2768: SELECT hzps.party_site_name, hzps.party_site_id
2769: INTO l_party_site_name,p_party_site_id
2770: FROM hz_party_sites hzps, ap_supplier_sites_all aps,
2771: HR_OPERATING_UNITS ORG
2772: WHERE ORG.name = p_org_name
2773: AND aps.org_id = ORG.organization_id
2774: AND hzps.party_site_name = p_party_site_name

Line 14362: FROM ap_supplier_sites_all

14358: IF i_vendor_id IS NULL THEN
14359: IF i_vendor_site_id IS NOT NULL THEN
14360: SELECT vendor_id
14361: INTO l_vendor_id
14362: FROM ap_supplier_sites_all
14363: WHERE vendor_site_id = i_vendor_site_id;
14364: END IF;
14365:
14366: IF i_vendor_contact_id IS NOT NULL THEN