DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2703: FROM mtl_material_transactions

2699: IF l_line_rec.source_type_code = 'EXTERNAL' THEN
2700: BEGIN
2701: SELECT transaction_date
2702: INTO x_source_line_rec.fulfilled_date
2703: FROM mtl_material_transactions
2704: WHERE transaction_type_id = l_drop_ship_txn_type_id
2705: AND trx_source_line_id = l_line_rec.line_id
2706: AND rownum = 1;
2707: EXCEPTION

Line 5047: mtl_material_transactions mmt

5043: mmt.transaction_type_id transaction_type_id,
5044: mmt.transaction_action_id transaction_action_id
5045: FROM mtl_system_items msi,
5046: mtl_unit_transactions mut,
5047: mtl_material_transactions mmt
5048: WHERE mmt.transaction_id = p_txn_id
5049: AND mmt.transaction_id = mut.transaction_id(+)
5050: AND msi.organization_id = mmt.organization_id
5051: AND msi.inventory_item_id = mmt.inventory_item_id

Line 5074: mtl_material_transactions mmt

5070: mmt.transaction_action_id transaction_action_id
5071: FROM mtl_system_items msi,
5072: mtl_unit_transactions mut,
5073: mtl_transaction_lot_numbers mtln,
5074: mtl_material_transactions mmt
5075: WHERE mmt.transaction_id = p_txn_id
5076: AND mmt.transaction_id = mtln.transaction_id(+)
5077: AND mtln.serial_transaction_id = mut.transaction_id(+)
5078: AND msi.organization_id = mmt.organization_id