DBA Data[Home] [Help]

APPS.PA_PWP_INVOICE_REL dependencies on PA_DRAFT_INVOICE_ITEMS

Line 59: , pa_draft_invoice_items pdii

55: ,'AUTOLINK' link_type
56: FROM pa_projects prj
57: , ra_customer_trx rac
58: , pa_draft_invoices pdi
59: , pa_draft_invoice_items pdii
60: , pa_cust_rev_dist_lines crdl
61: , pa_expenditure_items ei
62: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
63: AND prj.AUTO_RELEASE_PWP_INV = 'Y'

Line 166: , pa_draft_invoice_items pdii

162: END, 'Y') payment_status
163: FROM pa_projects prj
164: , ra_customer_trx rac
165: , pa_draft_invoices pdi
166: , pa_draft_invoice_items pdii
167: , pa_events pae
168: , pa_event_types pet
169: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
170: AND prj.AUTO_RELEASE_PWP_INV = 'N'

Line 745: , PA_DRAFT_INVOICE_ITEMS PDII

741: (
742: SELECT 1
743: FROM PA_EXPENDITURE_ITEMS EI
744: , PA_CUST_REV_DIST_LINES CRDL
745: , PA_DRAFT_INVOICE_ITEMS PDII
746: , PA_DRAFT_INVOICES PDI
747: , PA_PROJECTS PRJ
748: , PA_TASKS TASK
749: , PA_TASKS TOPTASK