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 229: -- bug 7430783 Changing validation table to ap_supplier_sites_all

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

Line 231: FROM ap_supplier_sites_all SITE

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

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

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

Line 241: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG

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

Line 312: FROM ap_supplier_sites_all SITE

308: IF x_org_id is NOT NULL THEN
309:
310: SELECT count(*)
311: INTO l_dup_count_org_id
312: FROM ap_supplier_sites_all SITE
313: WHERE SITE.vendor_id = x_vendor_id
314: AND SITE.org_id = x_org_id
315: AND ((x_vendor_site_ID is not null and SITE.vendor_site_ID <> x_vendor_site_ID) OR
316: (x_vendor_site_code is not null and UPPER(SITE.vendor_site_code) <> UPPER(x_vendor_site_code)))

Line 323: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG

319: ELSIF (x_org_id is NULL and x_org_name is NOT NULL) THEN
320:
321: SELECT count(*)
322: INTO l_dup_count_org_name
323: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG
324: WHERE SITE.vendor_id = x_vendor_id
325: AND ORG.name = x_org_name
326: AND SITE.org_id = ORG.organization_id
327: AND ((x_vendor_site_ID is not null and SITE.vendor_site_ID <> x_vendor_site_ID) OR

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

3171: BEGIN
3172: /*If party_site_id is null then we derive it based on the
3173: party_site_name field provided. But in case of Upgraded records there
3174: can be multiple records in hz_party_sites with same party_site_name
3175: for the same party. We can link the ap_supplier_sites_all table
3176: to get unique record based on the input info*/
3177:
3178: if(p_party_site_id is not null) then
3179: SELECT hzps.party_site_name, hzps.party_site_id

Line 3188: FROM hz_party_sites hzps, ap_supplier_sites_all aps

3184: AND aps.vendor_id = p_vendor_id;
3185: else
3186: SELECT hzps.party_site_name, hzps.party_site_id
3187: INTO l_party_site_name,p_party_site_id
3188: FROM hz_party_sites hzps, ap_supplier_sites_all aps
3189: WHERE aps.org_id = p_org_id
3190: AND hzps.party_site_name = p_party_site_name
3191: AND hzps.party_site_id = aps.party_site_id
3192: AND aps.vendor_id = p_vendor_id;

Line 3211: FROM hz_party_sites hzps, ap_supplier_sites_all aps,

3207:
3208: BEGIN
3209: SELECT hzps.party_site_name, hzps.party_site_id
3210: INTO l_party_site_name,p_party_site_id
3211: FROM hz_party_sites hzps, ap_supplier_sites_all aps,
3212: HR_OPERATING_UNITS ORG
3213: WHERE ORG.name = p_org_name
3214: AND aps.org_id = ORG.organization_id
3215: AND hzps.party_site_name = p_party_site_name

Line 17995: FROM ap_supplier_sites_all

17991: IF i_vendor_id IS NULL THEN
17992: IF i_vendor_site_id IS NOT NULL THEN
17993: SELECT vendor_id
17994: INTO l_vendor_id
17995: FROM ap_supplier_sites_all
17996: WHERE vendor_site_id = i_vendor_site_id;
17997: END IF;
17998:
17999: IF i_vendor_contact_id IS NOT NULL THEN