DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_PARTY_SITES

Line 483: ,hz_party_sites hps

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
487: AND hps.location_id=hl.location_id

Line 514: ,hz_party_sites hps

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
518: AND hps.location_id=hl.location_id