APPS.JA_CN_COA_EXP_PKG dependencies on HZ_PARTY_SITES

Line 1618: ,HZ_PARTY_SITES PARTY_SITE

1614: ,nvl(LOC.ADDRESS1, '') cust_addr
1615: BULK COLLECT INTO l_all_cust_city_addr
1616: FROM HZ_CUST_ACCT_SITES_ALL ADDR
1617: ,HZ_LOCATIONS LOC
1618: ,HZ_PARTY_SITES PARTY_SITE
1619: ,HZ_LOC_ASSIGNMENTS LOC_ASSIGN
1620: ,HZ_CUST_SITE_USES_ALL SU
1621: ,HR_ORGANIZATION_INFORMATION HOI
1622: WHERE --ADDR.CUST_ACCOUNT_ID alias CUSTOMER_ID in AR_ADDRESSES_V

Line 1673: ,HZ_PARTY_SITES HPS

1669: || DECODE(NVL(HCP.PHONE_AREA_CODE,''),'','','-')
1670: || HCP.PHONE_NUMBER cust_phone
1671: BULK COLLECT INTO l_all_cust_phone
1672: FROM HZ_CONTACT_POINTS HCP
1673: ,HZ_PARTY_SITES HPS
1674: WHERE HCP.OWNER_TABLE_ID(+)=HPS.PARTY_SITE_ID
1675: AND HCP.OWNER_TABLE_NAME='HZ_PARTY_SITES'
1676: AND NVL(HCP.PRIMARY_FLAG,'')='Y'
1677: AND NVL(HCP.STATUS,'')='A' --only 'Active' one

Line 1675: AND HCP.OWNER_TABLE_NAME='HZ_PARTY_SITES'

1671: BULK COLLECT INTO l_all_cust_phone
1672: FROM HZ_CONTACT_POINTS HCP
1673: ,HZ_PARTY_SITES HPS
1674: WHERE HCP.OWNER_TABLE_ID(+)=HPS.PARTY_SITE_ID
1675: AND HCP.OWNER_TABLE_NAME='HZ_PARTY_SITES'
1676: AND NVL(HCP.PRIMARY_FLAG,'')='Y'
1677: AND NVL(HCP.STATUS,'')='A' --only 'Active' one
1678: AND NVL(HCP.CONTACT_POINT_TYPE,'')='PHONE'
1679: AND NVL(HCP.PHONE_LINE_TYPE,'')='GEN' --only 'Telephone' type, just the code 'GEN'