APPS.AP_PO_AMT_MATCH_PKG dependencies on MTL_SYSTEM_ITEMS

Line 159: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;

155: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
156: G_Invoice_Date ap_invoices.invoice_date%TYPE;
157: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
158: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
159: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
160: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
161: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
162: -- Removed for bug 4277744
163: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;

Line 2163: mtl_system_items msi

2159: -- bug 5061826 -- new FROM clause that goes to base tables
2160: FROM PO_LINES_ALL PL,
2161: PO_LINE_LOCATIONS_ALL PLL,
2162: po_distributions pd,
2163: mtl_system_items msi
2164: WHERE pll.line_location_id = x_po_line_location_id
2165: and pd.line_location_id = pll.line_location_id
2166: AND PLL.PO_LINE_ID = PL.PO_LINE_ID
2167: and pd.po_distribution_id = nvl(x_po_distribution_id,pd.po_distribution_id)

Line 2174: MTL_SYSTEM_ITEMS MSI

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
2177: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)
2178: AND MSI.INVENTORY_ITEM_ID(+) = PLL.ITEM_ID