DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on MTL_SYSTEM_ITEMS

Line 173: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;

169: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
170: G_Invoice_Date ap_invoices.invoice_date%TYPE;
171: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
172: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
173: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
174: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
175: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
176: -- Removed for bug 4277744
177: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;

Line 2278: MTL_SYSTEM_ITEMS MSI,

2274: DECODE(X_Amount,l_full_mtch_amt,G_ASSESSABLE_VALUE, NULL),
2275: G_dflt_tax_class_code,
2276: G_PAY_AWT_GROUP_ID --bug 9689194
2277: FROM PO_DISTRIBUTIONS_AP_V PD,
2278: MTL_SYSTEM_ITEMS MSI,
2279: PO_AP_RECEIPT_MATCH_V RCV,
2280: RCV_SHIPMENT_LINES RSL,
2281: RCV_TRANSACTIONS RT --7015553
2282: WHERE RCV.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID