DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_TRANSACTION_REASONS

Line 2217: FROM mtl_transaction_reasons mtr

2213: -- Derive REASON_ID from REASON_NAME provided
2214: UPDATE wip_move_txn_interface wmti
2215: SET wmti.reason_id =
2216: (SELECT mtr.reason_id
2217: FROM mtl_transaction_reasons mtr
2218: WHERE mtr.reason_name = wmti.reason_name
2219: AND NVL(mtr.disable_date, SYSDATE) >= SYSDATE)
2220: WHERE wmti.group_id = g_group_id
2221: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2267: FROM mtl_transaction_reasons mtr

2263: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2264: AND (wmti.reason_id IS NOT NULL OR wmti.reason_name IS NOT NULL)
2265: AND NOT EXISTS
2266: (SELECT 'X'
2267: FROM mtl_transaction_reasons mtr
2268: WHERE mtr.reason_id = NVL(wmti.reason_id, mtr.reason_id)
2269: AND mtr.reason_name = NVL(wmti.reason_name, mtr.reason_name)
2270: AND NVL(mtr.disable_date, SYSDATE) >= SYSDATE);
2271: