DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1727: mtl_material_transactions mmt,

1723: FROM oe_order_headers_all ooh,
1724: oe_order_lines_all ool,
1725: mtl_system_items msi,
1726: mtl_unit_transactions mut,
1727: mtl_material_transactions mmt,
1728: mtl_secondary_inventories msei,
1729: hr_all_organization_units haou
1730: WHERE mmt.transaction_id = p_trx_id
1731: AND mmt.transaction_id = mut.transaction_id(+)

Line 1787: mtl_material_transactions mmt,

1783: oe_order_lines_all ool,
1784: mtl_system_items msi,
1785: mtl_unit_transactions mut,
1786: mtl_transaction_lot_numbers mtln,
1787: mtl_material_transactions mmt,
1788: mtl_secondary_inventories msei,
1789: hr_all_organization_units haou
1790: WHERE mmt.transaction_id = p_trx_id
1791: AND mmt.transaction_id = mtln.transaction_id(+)

Line 8477: FROM mtl_material_transactions

8473: INTO l_inventory_item_id,
8474: l_organization_id,
8475: l_source_line_id,
8476: l_source_quantity
8477: FROM mtl_material_transactions
8478: WHERE transaction_id = p_mtl_txn_id;
8479:
8480: csi_interface_pkg.get_source_info(
8481: p_source_table => l_oke_source_table,