APPS.AP_PO_AMT_MATCH_PKG dependencies on PO_LINE_LOCATIONS_AP_V

Line 1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1663: l_debug_info := 'Inserting Item Line Matched to a PO';
1664:
1665: -- perf bug 5058993
1666: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1668:
1669:
1670: INSERT INTO AP_INVOICE_LINES (
1671: INVOICE_ID,

Line 2053: FROM PO_LINE_LOCATIONS_AP_V PLL,

2049: and msi.inventory_item_id(+) = pl.item_id
2050: and msi.organization_id(+) = g_inventory_organization_id
2051: and rownum = 1;
2052: /* -- commented out older from clause below
2053: FROM PO_LINE_LOCATIONS_AP_V PLL,
2054: PO_DISTRIBUTIONS_AP_V PD,
2055: MTL_SYSTEM_ITEMS MSI
2056: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2057: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID

Line 3789: po_line_locations_ap_v pll

3785: AIL.PRODUCT_CATEGORY, --product_category
3786: AIL.USER_DEFINED_FISC_CLASS --user_defined_fisc_class
3787: FROM ap_invoices ai,
3788: ap_invoice_lines ail,
3789: po_line_locations_ap_v pll
3790: WHERE ai.invoice_id = x_corrected_invoice_id
3791: AND ail.invoice_id = ai.invoice_id
3792: AND ail.line_number = x_corrected_line_number
3793: AND pll.line_location_id = ail.po_line_location_id;