DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_TRANSACTION_REASONS

Line 2149: FROM mtl_transaction_reasons mtr

2145: -- Derive REASON_ID from REASON_NAME provided
2146: UPDATE wip_move_txn_interface wmti
2147: SET wmti.reason_id =
2148: (SELECT mtr.reason_id
2149: FROM mtl_transaction_reasons mtr
2150: WHERE mtr.reason_name = wmti.reason_name
2151: AND NVL(mtr.disable_date, SYSDATE) >= SYSDATE)
2152: WHERE wmti.group_id = g_group_id
2153: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2199: FROM mtl_transaction_reasons mtr

2195: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2196: AND (wmti.reason_id IS NOT NULL OR wmti.reason_name IS NOT NULL)
2197: AND NOT EXISTS
2198: (SELECT 'X'
2199: FROM mtl_transaction_reasons mtr
2200: WHERE mtr.reason_id = NVL(wmti.reason_id, mtr.reason_id)
2201: AND mtr.reason_name = NVL(wmti.reason_name, mtr.reason_name)
2202: AND NVL(mtr.disable_date, SYSDATE) >= SYSDATE);
2203: