APPS.CSI_UTL_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1646: FROM mtl_material_transactions mmt,

1642: l_order_line_rec.unit_price,
1643: l_order_line_rec.currency_code,
1644: l_order_line_rec.model_remnant_flag, --4344316
1645: l_order_line_rec.source_code
1646: FROM mtl_material_transactions mmt,
1647: oe_order_lines_all b,
1648: oe_order_headers_all c
1649: WHERE mmt.trx_source_line_id = b.line_id
1650: AND b.header_id = c.header_id

Line 3545: mtl_material_transactions mmt

3541: x_mtl_txn_rec.source_transaction_date,
3542: x_mtl_txn_rec.inv_material_transaction_id
3543: FROM oe_order_headers_all oeh,
3544: oe_order_lines_all oel,
3545: mtl_material_transactions mmt
3546: WHERE mmt.transaction_id = p_mtl_transaction_id
3547: AND oel.line_id = mmt.trx_source_line_id
3548: AND oeh.header_id = oel.header_id;
3549:

Line 6001: FROM mtl_material_transactions

5997: SELECT inventory_item_id,
5998: organization_id
5999: INTO l_item_control_rec.inventory_item_id,
6000: l_item_control_rec.organization_id
6001: FROM mtl_material_transactions
6002: WHERE transaction_id = p_mtl_txn_id;
6003:
6004: EXCEPTION
6005: WHEN no_data_found THEN

Line 7474: mtl_material_transactions mmt,mtl_unit_transactions mut

7470:
7471: SELECT 1 INTO l_lot_ctrl_code FROM dual WHERE (--condition
7472: EXISTS
7473: (SELECT * FROM
7474: mtl_material_transactions mmt,mtl_unit_transactions mut
7475: where mut.transaction_id(+) = mmt.transaction_id
7476: AND mmt.transaction_id = p_transaction_id
7477: )
7478: AND

Line 7483: mtl_material_transactions mmt, mtl_transaction_lot_numbers

7479: NOT EXISTS
7480: (
7481:
7482: SELECT * FROM
7483: mtl_material_transactions mmt, mtl_transaction_lot_numbers
7484: mtln,mtl_unit_transactions mut where
7485: mut.transaction_id(+) = mtln.serial_transaction_id
7486: and
7487: mtln.transaction_id = mmt.transaction_id

Line 7511: mtl_material_transactions mmt, mtl_transaction_lot_numbers

7507: SELECT 2 INTO l_lot_ctrl_code FROM dual WHERE EXISTS
7508: (--condition
7509:
7510: SELECT * FROM
7511: mtl_material_transactions mmt, mtl_transaction_lot_numbers
7512: mtln,mtl_unit_transactions mut where
7513: mut.transaction_id(+) = mtln.serial_transaction_id
7514: and
7515: mtln.transaction_id = mmt.transaction_id