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 PO_VENDOR_SITES_ALL

Line 227: --FROM po_vendor_sites_all SITE

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
231: AND UPPER(SITE.vendor_site_code) = UPPER(x_vendor_site_code);

Line 237: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG

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
241: AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)

Line 1493: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;

1489: p_vendor_id IN NUMBER,
1490: p_org_id IN NUMBER,
1491: x_valid OUT NOCOPY BOOLEAN
1492: ) IS
1493: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;
1494:
1495: BEGIN
1496: x_valid := TRUE;
1497:

Line 1500: FROM po_vendor_sites_all

1496: x_valid := TRUE;
1497:
1498: SELECT vendor_site_id
1499: INTO l_dummy
1500: FROM po_vendor_sites_all
1501: WHERE vendor_id = p_vendor_id
1502: AND vendor_site_id = p_default_pay_site_id
1503: AND org_id = p_org_id
1504: AND nvl(inactive_date, sysdate +1 ) > sysdate

Line 2145: FROM po_vendor_sites_all

2141: IF p_selling_company_identifier is not null THEN
2142:
2143: SELECT COUNT(vendor_id)
2144: INTO l_vendor_count
2145: FROM po_vendor_sites_all
2146: WHERE selling_company_identifier = p_selling_company_identifier
2147: AND vendor_id <> p_vendor_id;
2148:
2149: IF l_vendor_count > 0 THEN

Line 2524: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;

2520: p_int_table IN VARCHAR2,
2521: p_int_key IN VARCHAR2,
2522: x_valid OUT NOCOPY BOOLEAN) IS
2523:
2524: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;
2525: l_api_name CONSTANT VARCHAR2(30) := 'Check_Vendor_Site_Id';
2526: BEGIN
2527:
2528: x_valid := TRUE;

Line 2532: FROM po_vendor_sites_all

2528: x_valid := TRUE;
2529:
2530: SELECT vendor_site_id
2531: INTO l_dummy
2532: FROM po_vendor_sites_all
2533: WHERE vendor_site_id = p_vendor_site_id
2534: AND nvl(inactive_date, sysdate +1 ) > sysdate;
2535:
2536: EXCEPTION

Line 2589: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

2585: x_valid OUT NOCOPY BOOLEAN) IS
2586:
2587: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2588: l_org_name HR_OPERATING_UNITS.name%TYPE;
2589: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
2590: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name_Site_Code';
2591: BEGIN
2592: x_valid := TRUE;
2593:

Line 2604: FROM PO_VENDOR_SITES_ALL

2600: the vendor-site-code,we have split the statement into two cases*/
2601: if(p_vendor_site_id is not null) then
2602: SELECT vendor_site_code, vendor_site_id
2603: INTO l_vendor_site_code,p_vendor_site_id
2604: FROM PO_VENDOR_SITES_ALL
2605: WHERE org_id = p_org_id
2606: AND vendor_site_code = p_vendor_site_code
2607: AND vendor_site_id=p_vendor_site_id;
2608: else

Line 2611: FROM PO_VENDOR_SITES_ALL

2607: AND vendor_site_id=p_vendor_site_id;
2608: else
2609: SELECT vendor_site_code, vendor_site_id
2610: INTO l_vendor_site_code,p_vendor_site_id
2611: FROM PO_VENDOR_SITES_ALL
2612: WHERE org_id = p_org_id
2613: AND vendor_site_code=p_vendor_site_code;
2614: end if;
2615: /*Bug4592201*/

Line 2654: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG

2650:
2651: BEGIN
2652: SELECT SITE.vendor_site_code,vendor_site_id
2653: INTO l_vendor_site_code,p_vendor_site_id
2654: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG
2655: WHERE ORG.name = p_org_name
2656: AND SITE.org_id = ORG.organization_id
2657: AND SITE.vendor_site_code = p_vendor_site_code;
2658:

Line 8035: FROM po_vendor_sites_all pvs

8031:
8032: --get org_id from existing record
8033: SELECT org_id
8034: INTO l_org_id
8035: FROM po_vendor_sites_all pvs
8036: WHERE pvs.vendor_site_id = p_vendor_site_id;
8037:
8038: l_org_context := mo_global.get_access_mode;
8039:

Line 8556: FROM po_vendor_sites_all pvs

8552: ,l_vendor_site_rec.county
8553: ,l_vendor_site_rec.address_style
8554: ,l_vendor_site_rec.language
8555: -- bug 7673494 end
8556: FROM po_vendor_sites_all pvs
8557: WHERE pvs.vendor_site_id = p_vendor_site_id;
8558: ap_vendor_sites_pkg.update_row(
8559: p_vendor_site_rec => l_vendor_site_rec,
8560: p_last_update_date => sysdate,

Line 12272: FROM HZ_Party_Sites hps, po_vendor_sites_all pvs

12268: SELECT hps.party_id,
12269: hps.location_id
12270: INTO x_org_party_id,
12271: x_location_id
12272: FROM HZ_Party_Sites hps, po_vendor_sites_all pvs
12273: WHERE pvs.vendor_site_id = p_vendor_contact_rec.vendor_site_id
12274: AND pvs.party_site_id = hps.party_site_id;
12275:
12276: SELECT party_site_id

Line 13621: FROM Po_Vendor_Sites_All

13617: ext_payee_rec.payee_party_site_id := l_party_site_id;
13618:
13619: SELECT org_id
13620: INTO ext_payee_rec.payer_org_id
13621: FROM Po_Vendor_Sites_All
13622: WHERE vendor_site_id = l_vendor_site_id;
13623:
13624: -- As per the discussion with Omar/Jayanta, we will only
13625: -- have payables payment function and no more employee expenses