DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTION_REASONS

Line 3134: FROM MTL_TRANSACTION_REASONS MTR

3130: AND PROCESS_FLAG = 1
3131: AND REASON_ID IS NOT NULL
3132: AND NOT EXISTS (
3133: SELECT NULL
3134: FROM MTL_TRANSACTION_REASONS MTR
3135: WHERE MTR.REASON_ID = MTI.REASON_ID
3136: AND NVL(MTR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
3137:
3138: l_count := SQL%ROWCOUNT;

Line 15356: FROM MTL_TRANSACTION_REASONS MTR

15352:
15353: /* Get reason code info */
15354: CURSOR c_get_reason_info IS
15355: SELECT MTR.REASON_ID
15356: FROM MTL_TRANSACTION_REASONS MTR
15357: WHERE MTR.REASON_ID = p_reason_id
15358: AND NVL(MTR.DISABLE_DATE, SYSDATE + 1) > SYSDATE;
15359:
15360: /* get item information */