APPS.AR_GTA_ARTRX_PROC dependencies on HZ_PARTY_SITES

Line 2553: HZ_PARTY_SITES RAA_BILL_PS,

2549: RAA_BILL_LOC.Address_Lines_Phonetic))
2550: INTO l_raa_bill_to_concat_address
2551: FROM HZ_CUST_SITE_USES_ALL SU_BILL,
2552: Hz_Cust_Acct_Sites_All RAA_BILL,
2553: HZ_PARTY_SITES RAA_BILL_PS,
2554: Hz_Locations RAA_BILL_LOC,
2555: FND_TERRITORIES_VL FT_BILL,
2556: ra_customer_trx_all h
2557: WHERE h.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID

Line 2603: hz_party_sites hps,

2599: ,
2600: ra_customer_trx_all h
2601: --Yao add for bug#8769687
2602: ,
2603: hz_party_sites hps,
2604: hz_cust_acct_sites_all hcasa,
2605: hz_cust_site_uses_all hcsua
2606: --Yao add end
2607: WHERE -- h.bill_to_customer_id can find by customer trx id

Line 2617: AND p.owner_table_name(+) = 'HZ_PARTY_SITES'

2613: AND hcsua.cust_acct_site_id = hcasa.cust_acct_site_id
2614: AND hps.party_site_id = hcasa.party_site_id
2615: AND p.owner_table_id(+) = hcasa.party_site_id
2616: --Yao add or bug#8769687 end
2617: AND p.owner_table_name(+) = 'HZ_PARTY_SITES'
2618: AND p.CONTACT_POINT_TYPE(+) = 'PHONE'
2619: AND p.primary_flag(+) = 'Y'
2620: AND h.customer_trx_id = l_customer_trx_id;
2621: