DBA Data[Home] [Help]

APPS.CSI_INV_ISO_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2123: FROM mtl_material_transactions m1, mtl_material_transactions m2

2119:
2120: --Cursor modified for bug 5023673--
2121: CURSOR c_intransit_line_id (pc_transaction_id IN NUMBER) IS
2122: SELECT m2.trx_source_line_id
2123: FROM mtl_material_transactions m1, mtl_material_transactions m2
2124: WHERE m1.transaction_id = pc_transaction_id
2125: AND m1.transfer_transaction_id = m2.transaction_id;
2126:
2127: r_intransit_line_id c_intransit_line_id%rowtype;

Line 2158: from mtl_material_transactions

2154: r_so_info c_so_info%rowtype;
2155:
2156: CURSOR c_xfer_trans_id (pc_xfer_id IN NUMBER) IS
2157: SELECT trx_source_line_id
2158: from mtl_material_transactions
2159: WHERE transaction_id = pc_xfer_id;
2160:
2161: r_xfer_trans_id c_xfer_trans_id%rowtype;
2162:

Line 4119: FROM mtl_material_transactions

4115: SELECT transfer_transaction_id,
4116: transaction_action_id,
4117: transaction_type_id,
4118: transaction_quantity
4119: FROM mtl_material_transactions
4120: WHERE transaction_id = p_transaction_id;
4121:
4122: r_mtl c_mtl%rowtype;
4123: