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_SOD_DATA dependencies on AMW_VIOLATIONS

Line 1446: AMW_VIOLATIONS av,

1442: SELECT distinct acv.CONSTRAINT_REV_ID,
1443: acv.CONSTRAINT_NAME,
1444: avue.RESPONSIBILITY_ID
1445: FROM AMW_CONSTRAINTS_VL acv,
1446: AMW_VIOLATIONS av,
1447: AMW_VIOLATION_USERS avu,
1448: AMW_VIOLAT_USER_ENTRIES avue
1449: WHERE acv.START_DATE<= SYSDATE
1450: AND (acv.END_DATE IS NULL OR acv.END_DATE>=SYSDATE)

Line 1505: AMW_VIOLATIONS av,

1501: SELECT DISTINCT acv.CONSTRAINT_REV_ID,
1502: acv.CONSTRAINT_NAME,
1503: avue.FUNCTION_ID
1504: FROM AMW_CONSTRAINTS_VL acv,
1505: AMW_VIOLATIONS av,
1506: AMW_VIOLATION_USERS avu,
1507: AMW_VIOLAT_USER_ENTRIES avue
1508: WHERE acv.CONSTRAINT_REV_ID=av.CONSTRAINT_REV_ID
1509: AND av.VIOLATION_ID=avu.VIOLATION_ID

Line 1524: FROM AMW_VIOLATIONS av,

1520: CURSOR c_amw_violation_resp_entries IS
1521: SELECT DISTINCT acv.CONSTRAINT_REV_ID,
1522: acv.CONSTRAINT_NAME,
1523: avre.FUNCTION_ID
1524: FROM AMW_VIOLATIONS av,
1525: AMW_CONSTRAINTS_VL acv,
1526: AMW_VIOLATION_RESP avr,
1527: AMW_VIOLAT_RESP_ENTRIES avre
1528: WHERE av.CONSTRAINT_REV_ID = acv.CONSTRAINT_REV_ID