APPS.WIP_MOVPROC_PRIV dependencies on WIP_SERIAL_MOVE_INTERFACE

Line 2149: wip_serial_move_interface wsmi,

2145: SELECT msn.serial_number serial,
2146: NVL(msn.operation_seq_num, p_start_op) sn_op,
2147: NVL(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE) sn_step
2148: FROM mtl_serial_numbers msn,
2149: wip_serial_move_interface wsmi,
2150: wip_move_txn_interface wmti
2151: WHERE msn.inventory_item_id = wmti.primary_item_id
2152: AND msn.current_organization_id = wmti.organization_id
2153: -- msn.wip_entity_id will be null after complete to inventory. Need this

Line 2818: FROM wip_serial_move_interface wsmi,

2814: wsmi.program_id,
2815: wsmi.program_update_date,
2816: -- Add this column for OSFM serial support project.
2817: wsmi.gen_object_id
2818: FROM wip_serial_move_interface wsmi,
2819: wip_move_txn_interface wmti
2820: WHERE wsmi.transaction_id = wmti.transaction_id
2821: AND wmti.group_id = p_gib.group_id
2822: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 9047: wip_serial_move_interface wsmi

9043: wsmi.assembly_serial_number
9044: FROM mtl_transactions_interface mti,
9045: mtl_system_items msi,
9046: mtl_transaction_lots_interface mtli,
9047: wip_serial_move_interface wsmi
9048: WHERE mti.organization_id = msi.organization_id
9049: AND mti.inventory_item_id = msi.inventory_item_id
9050: AND mti.transaction_header_id = p_gib.assy_header_id
9051: AND mti.transaction_action_id = l_txn_action_id

Line 10484: wip_serial_move_interface wsmi,

10480: SET msn1.group_mark_id = msn1.wip_entity_id
10481: WHERE msn1.gen_object_id =
10482: (SELECT msn2.gen_object_id
10483: FROM wip_move_txn_interface wmti,
10484: wip_serial_move_interface wsmi,
10485: mtl_serial_numbers msn2
10486: WHERE wmti.transaction_id = wsmi.transaction_id
10487: AND wsmi.assembly_serial_number = msn2.serial_number
10488: AND wmti.primary_item_id = msn2.inventory_item_id

Line 10500: DELETE FROM wip_serial_move_interface

10496:
10497: /*--------------------------------------+
10498: | Delete serial move interface records |
10499: +--------------------------------------*/
10500: DELETE FROM wip_serial_move_interface
10501: WHERE transaction_id IN
10502: (SELECT transaction_id
10503: FROM wip_move_txn_interface
10504: WHERE group_id = p_group_id

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

11015: l_process_phase := '2';
11016: SAVEPOINT s_oa_txn_proc;
11017:
11018: IF(p_assySerial IS NOT NULL) THEN
11019: -- serial txns, so need to insert record into WIP_SERIAL_MOVE_INTERFACE too
11020: IF(wma_move.insertSerial(groupID => p_group_id,
11021: transactionID => p_group_id,
11022: serialNumber => p_assySerial,
11023: errMessage => l_error_msg) = FALSE) THEN