DBA Data[Home] [Help]

APPS.PA_MC_UPG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 785: FROM pa_draft_invoice_items

781: SELECT decode(invoice_line_type,'RETENTION',2,1) l_type, line_num,
782: event_task_id, event_num, invoice_line_type,amount /* added for bug 1946624 */
783: , bill_trans_currency_code, bill_trans_bill_amount /* MCB2 */
784: , projfunc_bill_amount, retention_rule_id,invproc_currency_code/* added bug 2966251 */
785: FROM pa_draft_invoice_items
786: WHERE project_id = rprojectid
787: AND draft_invoice_num = rdinvnum
788: ORDER BY 1,2;
789: