DBA Data[Home] [Help]

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 3503: mtl_material_transactions mmt

3499: x_mtl_txn_rec.source_transaction_date,
3500: x_mtl_txn_rec.inv_material_transaction_id
3501: FROM oe_order_headers_all oeh,
3502: oe_order_lines_all oel,
3503: mtl_material_transactions mmt
3504: WHERE mmt.transaction_id = p_mtl_transaction_id
3505: AND oel.line_id = mmt.trx_source_line_id
3506: AND oeh.header_id = oel.header_id;
3507:

Line 5922: FROM mtl_material_transactions

5918: SELECT inventory_item_id,
5919: organization_id
5920: INTO l_item_control_rec.inventory_item_id,
5921: l_item_control_rec.organization_id
5922: FROM mtl_material_transactions
5923: WHERE transaction_id = p_mtl_txn_id;
5924:
5925: EXCEPTION
5926: WHEN no_data_found THEN