APPS.PA_PWP_SUMM_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 101: FROM PA_DRAFT_INVOICES_ALL I

97: , l_user_id
98: , l_date
99: , l_user_id
100: , l_date
101: FROM PA_DRAFT_INVOICES_ALL I
102: , PA_DRAFT_INVOICES_ALL ORG_INV
103: , PA_CUSTOMERS_V C
104: ,PA_LOOKUPS LK
105: ,PA_AGREEMENTS_ALL A

Line 102: , PA_DRAFT_INVOICES_ALL ORG_INV

98: , l_date
99: , l_user_id
100: , l_date
101: FROM PA_DRAFT_INVOICES_ALL I
102: , PA_DRAFT_INVOICES_ALL ORG_INV
103: , PA_CUSTOMERS_V C
104: ,PA_LOOKUPS LK
105: ,PA_AGREEMENTS_ALL A
106: WHERE I.AGREEMENT_ID = A.AGREEMENT_ID

Line 258: pa_draft_invoices_all pda

254: (SELECT SUM(INV_AMOUNT ) -- bug 8225160
255: ,SUM(PROJFUNC_BILL_AMOUNT)
256: ,SUM(PROJECT_BILL_AMOUNT)
257: FROM pa_draft_invoice_items pdii,
258: pa_draft_invoices_all pda
259: WHERE pwp.project_id = pda.project_id
260: AND pwp.draft_invoice_num = pda.draft_invoice_num
261: AND pda.gl_date between l_start_date AND l_end_date
262: AND pdii.project_id = pwp.project_id

Line 387: FROM pa_draft_invoices_all pda

383: (SELECT pda.APPROVED_DATE
384: , pda.GL_DATE
385: , pda.RELEASED_DATE
386:
387: FROM pa_draft_invoices_all pda
388:
389: WHERE pwp.project_id = pda.project_id
390: AND pwp.draft_invoice_num = pda.draft_invoice_num
391:

Line 407: pa_draft_invoices_all pda,

403: bill_c.customer_name,
404: ship_c.customer_number,
405: ship_c.customer_name
406: from
407: pa_draft_invoices_all pda,
408: pa_customers_v bill_c,
409: pa_customers_v ship_c
410:
411: where

Line 451: pa_draft_invoices_all pda,

447: ship_p.address_lines_phonetic
448: ) ship_to_address
449:
450: from
451: pa_draft_invoices_all pda,
452: RA_ADDRESSES_ALL bill_p,
453: RA_ADDRESSES_ALL ship_p
454: where
455: bill_p.address_id(+) = pda.bill_to_address_id

Line 479: PA_DRAFT_INVOICES_ALL PDA ,

475: sa_loc.PROVINCE ,sa_loc.POSTAL_CODE ,TERR_S.TERRITORY_SHORT_NAME )
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 ,