DBA Data[Home] [Help]

APPS.PA_PWP_SUMM_PKG dependencies on HZ_PARTY_SITES

Line 481: hz_party_sites sa_party_site ,

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 ,
485: hz_cust_acct_sites ba_acct_site

Line 484: hz_party_sites ba_party_site ,

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 ,
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(+)