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 173: FROM MTL_TRANSACTION_TYPES

169:
170: -- Query for validating Transaction_Type_NAme and selecting Transaction_Type_Id
171: CURSOR Transaction_Type_Cur(p_Transaction_Type_name varchar2) IS
172: SELECT Transaction_Type_Id
173: FROM MTL_TRANSACTION_TYPES
174: WHERE TRANSACTION_TYPE_NAME = p_Transaction_Type_Name
175: AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);
176:
177: -- Query for Selcting Problem_Code

Line 3488: from MTL_TRANSACTION_TYPES

3484: AND TRUNC(SYSDATE) BETWEEN TRUNC(PERIOD_START_DATE) AND TRUNC(SCHEDULE_CLOSE_DATE);
3485:
3486: CURSOR TRX_ACTION_CUR(p_type_Id NUMBER) IS
3487: SELECT TRANSACTION_ACTION_ID,TRANSACTION_SOURCE_TYPE_ID
3488: from MTL_TRANSACTION_TYPES
3489: where TRANSACTION_TYPE_ID = p_type_Id;
3490:
3491: BEGIN
3492: l_Process_Flag := 'W';

Line 4119: from MTL_TRANSACTION_TYPES

4115: l_loop_count NUMBER;
4116:
4117: CURSOR TRX_ACTION_CUR(p_type_Id NUMBER) IS
4118: SELECT TRANSACTION_ACTION_ID,TRANSACTION_SOURCE_TYPE_ID
4119: from MTL_TRANSACTION_TYPES
4120: where TRANSACTION_TYPE_ID = p_type_Id;
4121:
4122: -- Fix for bug# 8607839(FP for Bug # 8575782) -- start
4123: CURSOR get_lot_dff_attrib(p_lot_number IN VARCHAR2) IS