DBA Data[Home] [Help]

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on HZ_CUST_ACCT_SITES

Line 3304: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

3300: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3301: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3302:
3303: l_party_site_id hz_party_sites.party_site_id%TYPE;
3304: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
3305: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
3306:
3307: l_bank_account VARCHAR2(110);
3308:

Line 3510: , hz_cust_acct_sites_all addr

3506: , l_customer_site_id
3507: , l_party_site_id
3508: FROM
3509: hz_cust_site_uses_all hcsua
3510: , hz_cust_acct_sites_all addr
3511: , hz_party_sites party_site
3512: , hz_locations loc
3513: , fnd_territories_tl terr
3514: WHERE addr.party_site_id = party_site.party_site_id