eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_TRANSACTION_TYPES

Line 162: FROM MTL_TRANSACTION_TYPES

158:
159: -- Query for validating Transaction_Type_NAme and selecting Transaction_Type_Id
160: CURSOR Transaction_Type_Cur(p_Transaction_Type_name varchar2) IS
161: SELECT Transaction_Type_Id
162: FROM MTL_TRANSACTION_TYPES
163: WHERE TRANSACTION_TYPE_NAME = p_Transaction_Type_Name
164: AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);
165:
166: -- Query for Selcting Problem_Code

Line 2921: from MTL_TRANSACTION_TYPES

2917: AND TRUNC(SYSDATE) BETWEEN TRUNC(PERIOD_START_DATE) AND TRUNC(SCHEDULE_CLOSE_DATE);
2918:
2919: CURSOR TRX_ACTION_CUR(p_type_Id NUMBER) IS
2920: SELECT TRANSACTION_ACTION_ID,TRANSACTION_SOURCE_TYPE_ID
2921: from MTL_TRANSACTION_TYPES
2922: where TRANSACTION_TYPE_ID = p_type_Id;
2923:
2924: BEGIN
2925: l_Process_Flag := 'W';

Line 3539: from MTL_TRANSACTION_TYPES

3535: l_loop_count NUMBER;
3536:
3537: CURSOR TRX_ACTION_CUR(p_type_Id NUMBER) IS
3538: SELECT TRANSACTION_ACTION_ID,TRANSACTION_SOURCE_TYPE_ID
3539: from MTL_TRANSACTION_TYPES
3540: where TRANSACTION_TYPE_ID = p_type_Id;
3541:
3542: BEGIN
3543: