APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDOR_SITES_ALL

Line 1353: TYPE t_sup_city_addr IS RECORD ( city PO_VENDOR_SITES_ALL.CITY%TYPE

1349:
1350: --For supplier
1351: l_vender_id PO_VENDORS.VENDOR_ID%TYPE;
1352: --For city and address of supplier
1353: TYPE t_sup_city_addr IS RECORD ( city PO_VENDOR_SITES_ALL.CITY%TYPE
1354: ,addr PO_VENDOR_SITES_ALL.ADDRESS_LINE1%TYPE
1355: );
1356: TYPE t_sup_city_addr_array IS TABLE OF t_sup_city_addr;
1357: l_all_sup_city_addr t_sup_city_addr_array;

Line 1354: ,addr PO_VENDOR_SITES_ALL.ADDRESS_LINE1%TYPE

1350: --For supplier
1351: l_vender_id PO_VENDORS.VENDOR_ID%TYPE;
1352: --For city and address of supplier
1353: TYPE t_sup_city_addr IS RECORD ( city PO_VENDOR_SITES_ALL.CITY%TYPE
1354: ,addr PO_VENDOR_SITES_ALL.ADDRESS_LINE1%TYPE
1355: );
1356: TYPE t_sup_city_addr_array IS TABLE OF t_sup_city_addr;
1357: l_all_sup_city_addr t_sup_city_addr_array;
1358: l_sup_city_addr t_sup_city_addr;

Line 1498: FROM PO_VENDOR_SITES_ALL PVSA

1494: nvl(PVSA.STATE, '')) sup_city
1495: */
1496: ,nvl(PVSA.ADDRESS_LINE1, '') sup_addr
1497: BULK COLLECT INTO l_all_sup_city_addr
1498: FROM PO_VENDOR_SITES_ALL PVSA
1499: ,HR_ORGANIZATION_INFORMATION HOI
1500: WHERE --Check "Primary Pay" Vendor site of OUs under current LE
1501: HOI.org_information_context = 'Operating Unit Information'
1502: AND HOI.Org_Information2 = l_le_id --using variable l_le_id

Line 1533: ,PO_VENDOR_SITES_ALL PVSA

1529: '0' || DECODE(nvl(PVC.AREA_CODE, ''), '', '', PVC.AREA_CODE || '-')
1530: || nvl(PVC.PHONE, '') sup_phone
1531: BULK COLLECT INTO l_all_sup_phone
1532: FROM PO_VENDOR_CONTACTS PVC
1533: ,PO_VENDOR_SITES_ALL PVSA
1534: ,HR_ORGANIZATION_INFORMATION HOI
1535: WHERE PVC.vendor_site_id = PVSA.vendor_site_id
1536: --Check "Primary Pay" Vendor site of OUs under current LE
1537: AND HOI.org_information_context = 'Operating Unit Information'