DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on AP_INVOICES_ALL

Line 624: ap_invoices_all inv

620: dist.line_type_lookup_code dist_type
621: FROM pa_cost_distribution_lines_all cdl,
622: pa_expenditure_items_all ei,
623: ap_invoice_distributions_all dist,
624: ap_invoices_all inv
625: WHERE cdl.expenditure_item_id = ei.expenditure_item_id
626: AND inv.invoice_id = to_number(cdl.system_reference2)
627: AND dist.invoice_id = to_number(cdl.system_reference2)
628: AND dist.invoice_id = inv.invoice_id