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.MTH_LOAD_TAG_READINGS_PKG dependencies on FND_LOOKUPS

Line 216: OR (TDM.MTH_ENTITY=8 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))

212: EQP.PLANT_FK_KEY is NULL OR
213: TM.STATUS is NULL OR
214: TM.STATUS <> 'ACTIVE' OR
215: (TDM.MTH_ENTITY=5 AND RAW_DATA.TAG_DATA NOT IN (1,2,3,4) )
216: OR (TDM.MTH_ENTITY=8 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))
217: OR (TDM.MTH_ENTITY=17 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))
218: OR (TDM.MTH_ENTITY=13 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) ) OR
219: (TDM.EQUIPMENT_FK_KEY IS NOT NULL
220: AND EQP.PLANT_FK_KEY is NOT NULL

Line 217: OR (TDM.MTH_ENTITY=17 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))

213: TM.STATUS is NULL OR
214: TM.STATUS <> 'ACTIVE' OR
215: (TDM.MTH_ENTITY=5 AND RAW_DATA.TAG_DATA NOT IN (1,2,3,4) )
216: OR (TDM.MTH_ENTITY=8 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))
217: OR (TDM.MTH_ENTITY=17 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))
218: OR (TDM.MTH_ENTITY=13 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) ) OR
219: (TDM.EQUIPMENT_FK_KEY IS NOT NULL
220: AND EQP.PLANT_FK_KEY is NOT NULL
221: AND TM.STATUS is NOT NULL

Line 218: OR (TDM.MTH_ENTITY=13 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) ) OR

214: TM.STATUS <> 'ACTIVE' OR
215: (TDM.MTH_ENTITY=5 AND RAW_DATA.TAG_DATA NOT IN (1,2,3,4) )
216: OR (TDM.MTH_ENTITY=8 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))
217: OR (TDM.MTH_ENTITY=17 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))
218: OR (TDM.MTH_ENTITY=13 AND RAW_DATA.TAG_DATA NOT IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) ) OR
219: (TDM.EQUIPMENT_FK_KEY IS NOT NULL
220: AND EQP.PLANT_FK_KEY is NOT NULL
221: AND TM.STATUS is NOT NULL
222: AND TM.STATUS = 'ACTIVE'

Line 311: AND (TDM.MTH_ENTITY<>8 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))

307: AND EQP.PLANT_FK_KEY is NOT NULL
308: AND TM.STATUS is NOT NULL
309: AND TM.STATUS = 'ACTIVE'
310: AND (((TDM.MTH_ENTITY<>5 OR RAW_DATA.TAG_DATA IN (1,2,3,4) )
311: AND (TDM.MTH_ENTITY<>8 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))
312: AND (TDM.MTH_ENTITY<>17 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))
313: AND (TDM.MTH_ENTITY<>13 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) )
314: OR TDM.MTH_ENTITY IS NULL)
315:

Line 312: AND (TDM.MTH_ENTITY<>17 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))

308: AND TM.STATUS is NOT NULL
309: AND TM.STATUS = 'ACTIVE'
310: AND (((TDM.MTH_ENTITY<>5 OR RAW_DATA.TAG_DATA IN (1,2,3,4) )
311: AND (TDM.MTH_ENTITY<>8 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))
312: AND (TDM.MTH_ENTITY<>17 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))
313: AND (TDM.MTH_ENTITY<>13 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) )
314: OR TDM.MTH_ENTITY IS NULL)
315:
316: AND NOT (TDM.MTH_ENTITY IS NULL And

Line 313: AND (TDM.MTH_ENTITY<>13 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) )

309: AND TM.STATUS = 'ACTIVE'
310: AND (((TDM.MTH_ENTITY<>5 OR RAW_DATA.TAG_DATA IN (1,2,3,4) )
311: AND (TDM.MTH_ENTITY<>8 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_DOWNTIME_REASON' ))
312: AND (TDM.MTH_ENTITY<>17 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_EQUIP_IDLE_REASON' ))
313: AND (TDM.MTH_ENTITY<>13 OR RAW_DATA.TAG_DATA IN (SELECT lookup_code FROM fnd_lookups WHERE lookup_type='MTH_SCRAP_REASON' )) )
314: OR TDM.MTH_ENTITY IS NULL)
315:
316: AND NOT (TDM.MTH_ENTITY IS NULL And
317: TDM.ATTRIBUTE_GROUP IS NULL And

Line 2133: SELECT Count(*) INTO v_count1 FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API_READINGS');

2129: MTH_HDL_EQP_UNSTAB_EVT();
2130: MTH_GEN_HDL_EQP_FAULT_EVENT ();
2131: MTH_GEN_HDL_SCRAP_EVENT();
2132: MTH_GEN_HDL_RECALIBRATION_EVT();
2133: SELECT Count(*) INTO v_count1 FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API_READINGS');
2134: IF (v_count1>0) THEN
2135: SELECT B.DESCRIPTION INTO v_desc1 FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API_READINGS');
2136: l_sql_stmt1:= 'BEGIN ' || v_desc1 || '; END;';
2137: BEGIN

Line 2135: SELECT B.DESCRIPTION INTO v_desc1 FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API_READINGS');

2131: MTH_GEN_HDL_SCRAP_EVENT();
2132: MTH_GEN_HDL_RECALIBRATION_EVT();
2133: SELECT Count(*) INTO v_count1 FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API_READINGS');
2134: IF (v_count1>0) THEN
2135: SELECT B.DESCRIPTION INTO v_desc1 FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API_READINGS');
2136: l_sql_stmt1:= 'BEGIN ' || v_desc1 || '; END;';
2137: BEGIN
2138: IF(v_desc1 IS NOT NULL )THEN
2139: EXECUTE IMMEDIATE l_sql_stmt1;

Line 2227: FROM FND_LOOKUPS B

2223: IF (p_ret_code <> 2) THEN
2224:
2225: SELECT Count(*)
2226: INTO v_count
2227: FROM FND_LOOKUPS B
2228: WHERE B.LOOKUP_TYPE IN ('MTH_TAG_BUS_RULES_PLSQL_API');
2229:
2230: IF (v_count>0) THEN
2231:

Line 2234: FROM FND_LOOKUPS B

2230: IF (v_count>0) THEN
2231:
2232: SELECT B.DESCRIPTION
2233: INTO v_desc
2234: FROM FND_LOOKUPS B
2235: WHERE B.LOOKUP_TYPE IN ('MTH_TAG_BUS_RULES_PLSQL_API');
2236:
2237: l_sql_stmt:= 'BEGIN ' || v_desc || '(:1); END;';
2238:

Line 2352: FROM FND_LOOKUPS B

2348: THEN
2349: -- Dbms_Output.put_line('p_ret_code1' || p_ret_code);
2350: SELECT Count(*)
2351: INTO v_count
2352: FROM FND_LOOKUPS B
2353: WHERE B.LOOKUP_TYPE IN ('MTH_TAG_BUS_RULES_PLSQL_API');
2354:
2355: IF (v_count>0) THEN
2356:

Line 2359: FROM FND_LOOKUPS B

2355: IF (v_count>0) THEN
2356:
2357: SELECT B.DESCRIPTION
2358: INTO v_desc
2359: FROM FND_LOOKUPS B
2360: WHERE B.LOOKUP_TYPE IN ('MTH_TAG_BUS_RULES_PLSQL_API');
2361: -- Dbms_Output.put_line('v_desc' || v_desc);
2362:
2363: l_sql_stmt:= 'BEGIN ' || v_desc || '(:1); END;';

Line 2495: SELECT B.DESCRIPTION INTO v_desc FROM FND_LOOKUPS B

2491: mth_util_pkg.truncate_table_partition('MTH_TAG_READINGS_RAW' ,v_current_processing_flag);
2492: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();
2493: IF(p_ret_code <> 2)
2494: THEN
2495: SELECT B.DESCRIPTION INTO v_desc FROM FND_LOOKUPS B
2496: WHERE B.LOOKUP_TYPE IN ('MTH_TAG_BUS_RULES_PLSQL_API');
2497: l_sql_stmt:= 'BEGIN ' || ' v_desc' || ' :1; ' || 'END;';
2498: EXECUTE IMMEDIATE l_sql_stmt USING OUT v_ret_code;
2499: IF(v_ret_code <> 2)