DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 482: ,hz_cust_acct_sites_all hca

478: ,p_account_header_tbl(tab_row).bill_to_state
479: ,p_account_header_tbl(tab_row).bill_to_postal_code
480: ,p_account_header_tbl(tab_row).bill_to_country
481: FROM hz_cust_site_uses_all hcs
482: ,hz_cust_acct_sites_all hca
483: ,hz_party_sites hps
484: ,hz_locations hl
485: WHERE hcs.cust_acct_site_id=hca.cust_acct_site_id
486: AND hca.party_site_id=hps.party_site_id

Line 513: ,hz_cust_acct_sites_all hca

509: ,p_account_header_tbl(tab_row).ship_to_state
510: ,p_account_header_tbl(tab_row).ship_to_postal_code
511: ,p_account_header_tbl(tab_row).ship_to_country
512: FROM hz_cust_site_uses_all hcs
513: ,hz_cust_acct_sites_all hca
514: ,hz_party_sites hps
515: ,hz_locations hl
516: WHERE hcs.cust_acct_site_id=hca.cust_acct_site_id
517: AND hca.party_site_id=hps.party_site_id