DBA Data[Home] [Help]

APPS.PA_PWP_SUMM_PKG dependencies on HZ_CUST_ACCT_SITES

Line 480: hz_cust_acct_sites sa_acct_site ,

476: SHIP_CONCATENATED_ADDRESS
477: FROM FND_TERRITORIES_TL TERR_B ,
478: FND_TERRITORIES_TL TERR_S ,
479: PA_DRAFT_INVOICES_ALL PDA ,
480: hz_cust_acct_sites sa_acct_site ,
481: hz_party_sites sa_party_site ,
482: hz_locations sa_loc ,
483: hz_locations ba_loc ,
484: hz_party_sites ba_party_site ,

Line 485: hz_cust_acct_sites ba_acct_site

481: hz_party_sites sa_party_site ,
482: hz_locations sa_loc ,
483: hz_locations ba_loc ,
484: hz_party_sites ba_party_site ,
485: hz_cust_acct_sites ba_acct_site
486: WHERE pda.project_id = pwp.project_id
487: AND pda.draft_invoice_num = pwp.draft_invoice_num
488: AND sa_loc.COUNTRY = TERR_S.TERRITORY_CODE(+)
489: AND ba_loc.COUNTRY = TERR_B.TERRITORY_CODE(+)