DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTION_REASONS

Line 2947: FROM MTL_TRANSACTION_REASONS MTR

2943: AND PROCESS_FLAG = 1
2944: AND REASON_ID IS NOT NULL
2945: AND NOT EXISTS (
2946: SELECT NULL
2947: FROM MTL_TRANSACTION_REASONS MTR
2948: WHERE MTR.REASON_ID = MTI.REASON_ID
2949: AND NVL(MTR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
2950:
2951: l_count := SQL%ROWCOUNT;

Line 14771: FROM MTL_TRANSACTION_REASONS MTR

14767:
14768: /* Get reason code info */
14769: CURSOR c_get_reason_info IS
14770: SELECT MTR.REASON_ID
14771: FROM MTL_TRANSACTION_REASONS MTR
14772: WHERE MTR.REASON_ID = p_reason_id
14773: AND NVL(MTR.DISABLE_DATE, SYSDATE + 1) > SYSDATE;
14774:
14775: /* get item information */