APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_VENDORS

Line 1938: from PO_VENDOR_SITES_ALL vsa, po_vendors pvn,

1934: NVL(fte.TERRITORY_SHORT_NAME,vsa.COUNTRY),
1935: vsa.zip INTO l_legal_buss_name, l_doing_bus_name, l_vendor_name,l_VENDOR_SITE_ID, l_vendor_site_code, l_vendor_addr_line1, l_vendor_addr_line2, l_vendor_addr_line3,
1936: l_vendor_city, l_vendor_province_code, l_vendor_province, l_vendor_state_code, l_vendor_state, l_vendor_country_code,
1937: l_vendor_country,l_vendor_zip
1938: from PO_VENDOR_SITES_ALL vsa, po_vendors pvn,
1939: fnd_territories_tl fte,
1940: FND_LOOKUP_VALUES FCL1,
1941: FND_LOOKUP_VALUES FCL2,
1942: FND_LOOKUP_VALUES FCL3

Line 2160: FROM po_vendors

2156: BEGIN
2157:
2158: SELECT vendor_name
2159: INTO p_orig_splr_name
2160: FROM po_vendors
2161: WHERE vendor_id = x_supplier_id;
2162:
2163: SELECT DOING_BUS_AS_NAME,
2164: CAGE_CODE,

Line 2300: FROM po_vendors

2296:
2297: BEGIN
2298: SELECT party_id
2299: INTO l_party_id
2300: FROM po_vendors
2301: WHERE vendor_id = x_supplier_id;
2302:
2303: SELECT flv.meaning
2304: BULK COLLECT INTO l_meanings_table

Line 2588: FROM po_vendors

2584:
2585: BEGIN
2586: SELECT vendor_name
2587: INTO p_orig_splr_name
2588: FROM po_vendors
2589: WHERE vendor_id = x_supplier_id;
2590: EXCEPTION
2591: WHEN No_Data_Found THEN
2592: p_orig_splr_name := NULL;

Line 2747: FROM po_vendors

2743: BEGIN
2744:
2745: SELECT vendor_name
2746: INTO p_orig_splr_name
2747: FROM po_vendors
2748: WHERE vendor_id = l_supplier_id;
2749:
2750: SELECT DOING_BUS_AS_NAME,
2751: CAGE_CODE,

Line 2879: FROM po_vendors

2875:
2876: BEGIN
2877: SELECT party_id
2878: INTO l_party_id
2879: FROM po_vendors
2880: WHERE vendor_id = l_supplier_id;
2881:
2882: SELECT flv.meaning
2883: BULK COLLECT INTO l_meanings_table