DBA Data[Home] [Help]

APPS.PA_PWP_INVOICE_LINKS dependencies on PA_DRAFT_INVOICE_ITEMS

Line 17: Select pdii.draft_invoice_num, 'A' From PA_DRAFT_INVOICE_ITEMS PDII ,

13: Select draft_invoice_num, 'M' link_type From PA_PWP_LINKED_INVOICES PWP
14: Where PWP.AP_INVOICE_ID = p_invoice_id
15: And PWP.PROJECT_ID = p_project_id
16: UNION ALL
17: Select pdii.draft_invoice_num, 'A' From PA_DRAFT_INVOICE_ITEMS PDII ,
18: PA_CUST_REV_DIST_LINES CRDL ,
19: PA_EXPENDITURE_ITEMS EI
20: Where PDII.project_id = crdl.project_id
21: And pdii.draft_invoice_num = crdl.draft_invoice_num