DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 623: ap_invoice_distributions_all dist,

619: inv.invoice_type_lookup_code doc_type,
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)