APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 3563: mtl_material_transactions mmt,

3559: mmt.transaction_action_id mtl_action_id,
3560: mmt.transaction_source_type_id mtl_source_type_id,
3561: mmt.transaction_source_id mtl_source_id
3562: FROM mtl_unit_transactions mut,
3563: mtl_material_transactions mmt,
3564: mtl_transaction_types mtt
3565: WHERE mut.serial_number = p_serial_number
3566: AND mut.inventory_item_id = p_item_id
3567: AND mmt.transaction_id = mut.transaction_id

Line 3581: mtl_material_transactions mmt,

3577: mmt.transaction_source_type_id mtl_source_type_id,
3578: mmt.transaction_source_id mtl_source_id
3579: FROM mtl_unit_transactions mut,
3580: mtl_transaction_lot_numbers mtln,
3581: mtl_material_transactions mmt,
3582: mtl_transaction_types mtt
3583: WHERE mut.serial_number = p_serial_number
3584: AND mut.inventory_item_id = p_item_id
3585: AND mtln.serial_transaction_id = mut.transaction_id

Line 3706: FROM mtl_material_transactions mmt,

3702:
3703: CURSOR issued_srl_cur IS
3704: SELECT mut.serial_number,
3705: mut.inventory_item_id
3706: FROM mtl_material_transactions mmt,
3707: mtl_unit_transactions mut
3708: WHERE mmt.transaction_source_type_id = 5
3709: AND mmt.transaction_action_id = 1
3710: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id

Line 3717: FROM mtl_material_transactions mmt,

3713: AND mut.inventory_item_id = mmt.inventory_item_id
3714: UNION
3715: SELECT mut.serial_number,
3716: mut.inventory_item_id
3717: FROM mtl_material_transactions mmt,
3718: mtl_transaction_lot_numbers mtln,
3719: mtl_unit_transactions mut
3720: WHERE mmt.transaction_source_type_id = 5
3721: AND mmt.transaction_action_id = 1

Line 9919: mtl_material_transactions mmt,

9915: FROM oe_order_headers_all ooh,
9916: oe_order_lines_all ool,
9917: mtl_system_items msi,
9918: mtl_unit_transactions mut,
9919: mtl_material_transactions mmt,
9920: mtl_secondary_inventories msei,
9921: hr_all_organization_units haou
9922: WHERE mmt.transaction_id = p_mtl_txn_id
9923: AND mmt.transaction_id = mut.transaction_id(+)

Line 9978: mtl_material_transactions mmt,

9974: oe_order_lines_all ool,
9975: mtl_system_items msi,
9976: mtl_unit_transactions mut,
9977: mtl_transaction_lot_numbers mtln,
9978: mtl_material_transactions mmt,
9979: mtl_secondary_inventories msei,
9980: hr_all_organization_units haou
9981: WHERE mmt.transaction_id = p_mtl_txn_id
9982: AND mmt.transaction_id = mtln.transaction_id(+)

Line 10007: FROM mtl_material_transactions

10003: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
10004:
10005: SELECT trx_source_line_id
10006: INTO p_order_line_id
10007: FROM mtl_material_transactions
10008: WHERE transaction_id = p_mtl_txn_id;
10009:
10010: csi_t_gen_utility_pvt.build_file_name(
10011: p_file_segment1 => 'csisoful',