DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

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

697: Select draft_invoice_num, 'M' link_type From PA_PWP_LINKED_INVOICES PWP
698: Where PWP.AP_INVOICE_ID = p_invoice_id
699: And PWP.PROJECT_ID = p_project_id
700: UNION ALL
701: Select pdii.draft_invoice_num, 'A' From PA_DRAFT_INVOICE_ITEMS PDII ,
702: PA_CUST_REV_DIST_LINES CRDL ,
703: PA_EXPENDITURE_ITEMS EI
704: Where PDII.project_id = crdl.project_id
705: And pdii.draft_invoice_num = crdl.draft_invoice_num

Line 727: Select ei.document_header_id From PA_DRAFT_INVOICE_ITEMS PDII ,

723: Where PWP.draft_invoice_num = P_Draft_Inv_Num
724: And PWP.PROJECT_ID = p_project_id
725: And ap_Invoice_Id is not null
726: UNION ALL
727: Select ei.document_header_id From PA_DRAFT_INVOICE_ITEMS PDII ,
728: PA_CUST_REV_DIST_LINES CRDL ,
729: PA_EXPENDITURE_ITEMS EI
730: Where PDII.project_id = crdl.project_id
731: And pdii.draft_invoice_num = P_Draft_Inv_Num