APPS.CSI_INV_ISO_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2129: FROM mtl_material_transactions m1, mtl_material_transactions m2

2125:
2126: --Cursor modified for bug 5023673--
2127: CURSOR c_intransit_line_id (pc_transaction_id IN NUMBER) IS
2128: SELECT m2.trx_source_line_id
2129: FROM mtl_material_transactions m1, mtl_material_transactions m2
2130: WHERE m1.transaction_id = pc_transaction_id
2131: AND m1.transfer_transaction_id = m2.transaction_id;
2132:
2133: r_intransit_line_id c_intransit_line_id%rowtype;

Line 2164: from mtl_material_transactions

2160: r_so_info c_so_info%rowtype;
2161:
2162: CURSOR c_xfer_trans_id (pc_xfer_id IN NUMBER) IS
2163: SELECT trx_source_line_id
2164: from mtl_material_transactions
2165: WHERE transaction_id = pc_xfer_id;
2166:
2167: r_xfer_trans_id c_xfer_trans_id%rowtype;
2168:

Line 4139: FROM mtl_material_transactions

4135: SELECT transfer_transaction_id,
4136: transaction_action_id,
4137: transaction_type_id,
4138: transaction_quantity
4139: FROM mtl_material_transactions
4140: WHERE transaction_id = p_transaction_id;
4141:
4142: r_mtl c_mtl%rowtype;
4143: