DBA Data[Home] [Help]

APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on HZ_CUST_ACCT_SITES

Line 3569: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

3565: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3566: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3567:
3568: l_party_site_id hz_party_sites.party_site_id%TYPE;
3569: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
3570: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
3571:
3572: -- modified by allen yang 17/Jun/2009 for bug 8605196 to display bank info in Chinese
3573: -------------------------------------------------------------------------------------

Line 3908: , hz_cust_acct_sites_all addr

3904: , l_customer_site_id
3905: , l_party_site_id
3906: FROM
3907: hz_cust_site_uses_all hcsua
3908: , hz_cust_acct_sites_all addr
3909: , hz_party_sites party_site
3910: , hz_locations loc
3911: , fnd_territories_tl terr
3912: WHERE addr.party_site_id = party_site.party_site_id