APPS.INV_DIAG_PI_SUBLOC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 61: FROM mtl_material_transactions mmt

57: ORDER BY moqd.organization_id, moqd.inventory_item_id, moqd.create_transaction_id, moqd.update_transaction_id, moqd.locator_id;
58:
59: CURSOR c_phy_adj ( cp_n_cre_trx_id IN NUMBER, cp_upd_trx_id IN NUMBER) IS
60: SELECT mmt.physical_adjustment_id
61: FROM mtl_material_transactions mmt
62: WHERE (mmt.transaction_id = cp_n_cre_trx_id OR mmt.transaction_id = cp_upd_trx_id)
63: AND mmt.physical_adjustment_id IS NOT NULL;
64:
65: BEGIN

Line 124: ' FROM mtl_material_transactions mmt ' ||

120: ' , mmt.revision "Rev" ' ||
121: ' , mmt.physical_adjustment_id "Physical Adj Id"' ||
122: ' , mmt.transaction_source_id "Txn Source Id" ' ||
123: ' , mmt.transaction_source_name "Txn Source"' ||
124: ' FROM mtl_material_transactions mmt ' ||
125: ' , mtl_item_flexfields mif ' ||
126: ' , mtl_transaction_types tt ' ||
127: ' , mtl_txn_source_types st ' ||
128: ' , mfg_lookups ml ' ||