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.MSC_CL_AHL_ODS_LOAD dependencies on MSC_ST_RESERVATIONS

Line 2103: FROM MSC_ST_RESERVATIONS

2099: REQUIREMENT_DATE,
2100: SUBINVENTORY,
2101: TASK_ID,
2102: PROJECT_ID
2103: FROM MSC_ST_RESERVATIONS
2104: WHERE deleted_flag = MSC_UTIL.SYS_NO
2105: AND SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;
2106:
2107: CURSOR c_del IS

Line 2111: FROM MSC_ST_RESERVATIONS

2107: CURSOR c_del IS
2108: SELECT TRANSACTION_ID,
2109: ORGANIZATION_ID,
2110: SR_INSTANCE_ID
2111: FROM MSC_ST_RESERVATIONS
2112: WHERE deleted_flag = MSC_UTIL.SYS_YES
2113: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
2114: BEGIN
2115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');

Line 2208: ||' FROM MSC_ST_RESERVATIONS ms,'

2204: ||':v_current_date,'
2205: ||':v_current_user,'
2206: ||':v_current_date,'
2207: ||':v_current_user'
2208: ||' FROM MSC_ST_RESERVATIONS ms,'
2209: ||' MSC_ITEM_ID_LID mil '
2210: ||' WHERE ms.SR_INSTANCE_ID= '
2211: ||MSC_CL_COLLECTION.v_instance_id
2212: ||' AND mil.sr_instance_id = ms.sr_instance_id'