APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 3611: mtl_material_transactions mmt,

3607: mmt.transaction_action_id mtl_action_id,
3608: mmt.transaction_source_type_id mtl_source_type_id,
3609: mmt.transaction_source_id mtl_source_id
3610: FROM mtl_unit_transactions mut,
3611: mtl_material_transactions mmt,
3612: mtl_transaction_types mtt
3613: WHERE mut.serial_number = p_serial_number
3614: AND mut.inventory_item_id = p_item_id
3615: AND mmt.transaction_id = mut.transaction_id

Line 3629: mtl_material_transactions mmt,

3625: mmt.transaction_source_type_id mtl_source_type_id,
3626: mmt.transaction_source_id mtl_source_id
3627: FROM mtl_unit_transactions mut,
3628: mtl_transaction_lot_numbers mtln,
3629: mtl_material_transactions mmt,
3630: mtl_transaction_types mtt
3631: WHERE mut.serial_number = p_serial_number
3632: AND mut.inventory_item_id = p_item_id
3633: AND mtln.serial_transaction_id = mut.transaction_id

Line 3754: FROM mtl_material_transactions mmt,

3750:
3751: CURSOR issued_srl_cur IS
3752: SELECT mut.serial_number,
3753: mut.inventory_item_id
3754: FROM mtl_material_transactions mmt,
3755: mtl_unit_transactions mut
3756: WHERE mmt.transaction_source_type_id = 5
3757: AND mmt.transaction_action_id = 1
3758: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id

Line 3765: FROM mtl_material_transactions mmt,

3761: AND mut.inventory_item_id = mmt.inventory_item_id
3762: UNION
3763: SELECT mut.serial_number,
3764: mut.inventory_item_id
3765: FROM mtl_material_transactions mmt,
3766: mtl_transaction_lot_numbers mtln,
3767: mtl_unit_transactions mut
3768: WHERE mmt.transaction_source_type_id = 5
3769: AND mmt.transaction_action_id = 1

Line 10935: mtl_material_transactions mmt,

10931: FROM oe_order_headers_all ooh,
10932: oe_order_lines_all ool,
10933: mtl_system_items msi,
10934: mtl_unit_transactions mut,
10935: mtl_material_transactions mmt,
10936: mtl_secondary_inventories msei,
10937: hr_all_organization_units haou
10938: WHERE mmt.transaction_id = p_mtl_txn_id
10939: AND mmt.transaction_id = mut.transaction_id(+)

Line 10994: mtl_material_transactions mmt,

10990: oe_order_lines_all ool,
10991: mtl_system_items msi,
10992: mtl_unit_transactions mut,
10993: mtl_transaction_lot_numbers mtln,
10994: mtl_material_transactions mmt,
10995: mtl_secondary_inventories msei,
10996: hr_all_organization_units haou
10997: WHERE mmt.transaction_id = p_mtl_txn_id
10998: AND mmt.transaction_id = mtln.transaction_id(+)

Line 11023: FROM mtl_material_transactions

11019: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
11020:
11021: SELECT trx_source_line_id
11022: INTO p_order_line_id
11023: FROM mtl_material_transactions
11024: WHERE transaction_id = p_mtl_txn_id;
11025:
11026: csi_t_gen_utility_pvt.build_file_name(
11027: p_file_segment1 => 'csisoful',