APPS.WIP_MOVPROC_PRIV dependencies on WIP_SERIAL_MOVE_INTERFACE

Line 2270: wip_serial_move_interface wsmi,

2266: SELECT msn.serial_number serial,
2267: NVL(msn.operation_seq_num, p_start_op) sn_op,
2268: NVL(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE) sn_step
2269: FROM mtl_serial_numbers msn,
2270: wip_serial_move_interface wsmi,
2271: wip_move_txn_interface wmti
2272: WHERE msn.inventory_item_id = wmti.primary_item_id
2273: AND msn.current_organization_id = wmti.organization_id
2274: -- msn.wip_entity_id will be null after complete to inventory. Need this

Line 2947: FROM wip_serial_move_interface wsmi,

2943: wsmi.program_id,
2944: wsmi.program_update_date,
2945: -- Add this column for OSFM serial support project.
2946: wsmi.gen_object_id
2947: FROM wip_serial_move_interface wsmi,
2948: wip_move_txn_interface wmti
2949: WHERE wsmi.transaction_id = wmti.transaction_id
2950: AND wmti.group_id = p_gib.group_id
2951: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 9320: wip_serial_move_interface wsmi

9316: wsmi.assembly_serial_number
9317: FROM mtl_transactions_interface mti,
9318: mtl_system_items msi,
9319: mtl_transaction_lots_interface mtli,
9320: wip_serial_move_interface wsmi
9321: WHERE mti.organization_id = msi.organization_id
9322: AND mti.inventory_item_id = msi.inventory_item_id
9323: AND mti.transaction_header_id = p_gib.assy_header_id
9324: AND mti.transaction_action_id = l_txn_action_id

Line 10841: wip_serial_move_interface wsmi,

10837: SET msn1.group_mark_id = msn1.wip_entity_id
10838: WHERE msn1.gen_object_id =
10839: (SELECT msn2.gen_object_id
10840: FROM wip_move_txn_interface wmti,
10841: wip_serial_move_interface wsmi,
10842: mtl_serial_numbers msn2
10843: WHERE wmti.transaction_id = wsmi.transaction_id
10844: AND wsmi.assembly_serial_number = msn2.serial_number
10845: AND wmti.primary_item_id = msn2.inventory_item_id

Line 10857: DELETE FROM wip_serial_move_interface

10853:
10854: /*--------------------------------------+
10855: | Delete serial move interface records |
10856: +--------------------------------------*/
10857: DELETE FROM wip_serial_move_interface
10858: WHERE transaction_id IN
10859: (SELECT transaction_id
10860: FROM wip_move_txn_interface
10861: WHERE group_id = p_group_id

Line 11381: -- serial txns, so need to insert record into WIP_SERIAL_MOVE_INTERFACE too

11377: l_process_phase := '2';
11378: SAVEPOINT s_oa_txn_proc;
11379:
11380: IF(p_assySerial IS NOT NULL) THEN
11381: -- serial txns, so need to insert record into WIP_SERIAL_MOVE_INTERFACE too
11382: IF(wma_move.insertSerial(groupID => p_group_id,
11383: transactionID => p_group_id,
11384: serialNumber => p_assySerial,
11385: errMessage => l_error_msg) = FALSE) THEN