APPS.JA_CN_COA_EXP_PKG dependencies on HZ_PARTY_SITES

Line 1620: ,HZ_PARTY_SITES PARTY_SITE

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

Line 1675: ,HZ_PARTY_SITES HPS

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

Line 1677: AND HCP.OWNER_TABLE_NAME='HZ_PARTY_SITES'

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