DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on WSM_SERIAL_TXN_INTERFACE

Line 11003: -- DELETE wsm_serial_txn_interface

10999:
11000: -- ST : Serial Support Project --
11001: -- User inserted records...
11002:
11003: -- DELETE wsm_serial_txn_interface
11004: -- WHERE header_id in (SELECT header_id
11005: -- from wsm_lot_move_txn_interface wlmti
11006: -- WHERE group_id = l_wmti_group_id
11007: -- and status = WIP_CONSTANTS.COMPLETED

Line 11015: -- DELETE wsm_serial_txn_interface

11011: -- AND action_flag in (1,2,3,4,5,6)
11012: -- and transaction_type_id = 2;
11013: --
11014: -- -- Delete the inserted records for Attributes...
11015: -- DELETE wsm_serial_txn_interface
11016: -- WHERE header_id IN (Select wmt.transaction_id
11017: -- from wip_move_transactions wmt,
11018: -- wsm_lot_move_txn_interface wlmti
11019: -- where wlmti.group_id = l_wmti_group_id

Line 11035: DELETE wsm_serial_txn_interface

11031: -- ST : Serial Support Project --
11032: -- User inserted records...
11033: IF l_header_id_tbl.count > 0 THEN
11034: forall l_index in l_header_id_tbl.first..l_header_id_tbl.last
11035: DELETE wsm_serial_txn_interface
11036: WHERE header_id = l_header_id_tbl(l_index)
11037: AND transaction_type_id = 2;
11038: END IF;
11039: -- ST : Serial Support Project --