DBA Data[Home] [Help]

APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDOR_CONTACTS

Line 1530: FROM PO_VENDOR_CONTACTS PVC

1526: SELECT DISTINCT
1527: '0' || DECODE(nvl(PVC.AREA_CODE, ''), '', '', PVC.AREA_CODE || '-')
1528: || nvl(PVC.PHONE, '') sup_phone
1529: BULK COLLECT INTO l_all_sup_phone
1530: FROM PO_VENDOR_CONTACTS PVC
1531: ,PO_VENDOR_SITES_ALL PVSA
1532: ,HR_ORGANIZATION_INFORMATION HOI
1533: WHERE PVC.vendor_site_id = PVSA.vendor_site_id
1534: --Check "Primary Pay" Vendor site of OUs under current LE

Line 1550: FROM PO_VENDOR_CONTACTS PVC

1546: nvl(PVC.AREA_CODE, '')
1547: || DECODE(NVL(PVC.AREA_CODE, ''),'','','-')
1548: || nvl(PVC.PHONE, '') sup_phone
1549: BULK COLLECT INTO l_all_sup_phone
1550: FROM PO_VENDOR_CONTACTS PVC
1551: ,AP_SUPPLIER_SITES_ALL ASSA
1552: WHERE PVC.VENDOR_SITE_ID=ASSA.VENDOR_SITE_ID
1553: AND ASSA.VENDOR_ID=l_vender_id --using variable l_vender_id
1554: AND nvl(ASSA.PRIMARY_PAY_SITE_FLAG, 'N') = 'Y';