[Home] [Help]
1396: HLC.COUNTRY, NVL(FTE.TERRITORY_SHORT_NAME,HLC.COUNTRY) country_name,
1397: hlc.postal_code,
1398: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1399: FROM HR_LOCATIONS HLC,
1400: FND_TERRITORIES_TL FTE,
1401: FND_LOOKUP_VALUES FCL1,
1402: FND_LOOKUP_VALUES FCL2,
1403: FND_LOOKUP_VALUES FCL3
1404: WHERE HLC.LOCATION_ID = :1
1514: HLC.COUNTRY, NVL(FTE.TERRITORY_SHORT_NAME,HLC.COUNTRY) country_name,
1515: hlc.postal_code,
1516: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1517: FROM HR_LOCATIONS HLC,
1518: FND_TERRITORIES_TL FTE,
1519: FND_LOOKUP_VALUES FCL1,
1520: FND_LOOKUP_VALUES FCL2,
1521: FND_LOOKUP_VALUES FCL3
1522: WHERE HLC.LOCATION_ID = :1
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
1943: where vsa.vendor_site_id = p_supplier_site_id
3135: HLC.COUNTRY, NVL(FTE.TERRITORY_SHORT_NAME,HLC.COUNTRY) country_name,
3136: hlc.postal_code,
3137: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
3138: FROM HR_LOCATIONS HLC,
3139: FND_TERRITORIES_TL FTE,
3140: FND_LOOKUP_VALUES FCL1,
3141: FND_LOOKUP_VALUES FCL2,
3142: FND_LOOKUP_VALUES FCL3
3143: WHERE HLC.LOCATION_ID = :1