DBA Data[Home] [Help]

APPS.PA_MC_UPG dependencies on PA_DRAFT_INVOICES

Line 772: FROM PA_Draft_Invoices dic,

768: NVL(di.retention_invoice_flag,'N') retention_invoice_flag, /* added bug2966251 */
769: dic.canceled_flag canceled_flag,
770: di.canceled_flag orig_canceled_flag,
771: di.invoice_date invoice_date
772: FROM PA_Draft_Invoices dic,
773: PA_Draft_Invoices di
774: WHERE di.project_id = rprojectid
775: AND dic.project_id(+) = di.project_id
776: AND dic.draft_invoice_num(+) = di.draft_Invoice_num_credited

Line 773: PA_Draft_Invoices di

769: dic.canceled_flag canceled_flag,
770: di.canceled_flag orig_canceled_flag,
771: di.invoice_date invoice_date
772: FROM PA_Draft_Invoices dic,
773: PA_Draft_Invoices di
774: WHERE di.project_id = rprojectid
775: AND dic.project_id(+) = di.project_id
776: AND dic.draft_invoice_num(+) = di.draft_Invoice_num_credited
777: ORDER BY 1;