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.AMW_LOAD_PROC_DATA dependencies on AMW_PROC_HIERARCHY_DENORM

Line 374: FROM AMW_PROC_HIERARCHY_DENORM

370: L_HIER_DENORM_CHK := null;
371: BEGIN
372: SELECT 1
373: INTO L_HIER_DENORM_CHK
374: FROM AMW_PROC_HIERARCHY_DENORM
375: WHERE PARENT_CHILD_ID=L_PARENT_PROCESS_ID
376: AND PROCESS_ID=L_PROCESS_ID
377: AND UP_DOWN_IND='D';
378: EXCEPTION

Line 1320: FROM AMW_PROC_HIERARCHY_DENORM

1316: IS
1317:
1318: CURSOR c_INV_HIER IS
1319: SELECT 'Y'
1320: FROM AMW_PROC_HIERARCHY_DENORM
1321: WHERE PROCESS_ID IN (SELECT PROCESS_ID
1322: FROM AMW_PROCESS_VL
1323: WHERE PROCESS_CODE=p_PARENT_child_CODE)
1324: AND PARENT_CHILD_ID IN (SELECT PROCESS_ID

Line 1350: ,AMW_PROC_HIERARCHY_DENORM APHD

1346: IS
1347: CURSOR C_INV_APPR IS
1348: SELECT distinct 'Y'
1349: FROM AMW_LATEST_REVISIONS_V ALRV
1350: ,AMW_PROC_HIERARCHY_DENORM APHD
1351: WHERE APHD.UP_DOWN_IND='D'
1352: AND ALRV.PROCESS_ID=APHD.PARENT_CHILD_ID
1353: AND APHD.PROCESS_ID IN (SELECT ALRV.PROCESS_ID
1354: FROM AMW_LATEST_REVISIONS_V ALRV