DBA Data[Home] [Help]

APPS.PA_PWP_INVOICE_REL dependencies on PA_DRAFT_INVOICE_ITEMS

Line 56: pa_draft_invoice_items pdii ,

52: SELECT /*+ leading(aha) */ pdi.project_id , pdi.draft_invoice_num , EI.document_header_id -- leading Hint Added for bug#12404156
53: AP_INVOICE_ID , 'AUTOLINK' link_type
54: FROM pa_projects prj ,
55: pa_draft_invoices pdi ,
56: pa_draft_invoice_items pdii ,
57: pa_cust_rev_dist_lines crdl ,
58: pa_expenditure_items ei ,
59: ( select distinct invoice_id
60: from ap_holds_all

Line 159: , pa_draft_invoice_items pdii

155: END, 'Y') payment_status
156: FROM pa_projects prj
157: , ra_customer_trx rac
158: , pa_draft_invoices pdi
159: , pa_draft_invoice_items pdii
160: , pa_events pae
161: , pa_event_types pet
162: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
163: AND prj.AUTO_RELEASE_PWP_INV = 'N'

Line 749: , PA_DRAFT_INVOICE_ITEMS PDII

745: (
746: SELECT 1
747: FROM PA_EXPENDITURE_ITEMS EI
748: , PA_CUST_REV_DIST_LINES CRDL
749: , PA_DRAFT_INVOICE_ITEMS PDII
750: , PA_DRAFT_INVOICES PDI
751: , PA_PROJECTS PRJ
752: , PA_TASKS TASK
753: , PA_TASKS TOPTASK