eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PO_AMT_MATCH_PKG dependencies on PO_LINE_LOCATIONS_AP_V

Line 1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1779: --End Bug#13505998
1780:
1781: -- perf bug 5058993
1782: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1784:
1785:
1786: INSERT INTO AP_INVOICE_LINES (
1787: INVOICE_ID,

Line 2172: FROM PO_LINE_LOCATIONS_AP_V PLL,

2168: and msi.inventory_item_id(+) = pl.item_id
2169: and msi.organization_id(+) = g_inventory_organization_id
2170: and rownum = 1;
2171: /* -- commented out older from clause below
2172: FROM PO_LINE_LOCATIONS_AP_V PLL,
2173: PO_DISTRIBUTIONS_AP_V PD,
2174: MTL_SYSTEM_ITEMS MSI
2175: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2176: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID

Line 3946: po_line_locations_ap_v pll

3942: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
3943: g_pay_awt_group_id --Bug 9689194
3944: FROM ap_invoices ai,
3945: ap_invoice_lines ail,
3946: po_line_locations_ap_v pll
3947: WHERE ai.invoice_id = x_corrected_invoice_id
3948: AND ail.invoice_id = ai.invoice_id
3949: AND ail.line_number = x_corrected_line_number
3950: AND pll.line_location_id = ail.po_line_location_id;