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_VIOLAT_USER_ENTRIES

Line 1414: -- 1. AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID

1410: -- cst_table_update_report
1411: -- Purpose
1412: -- Report the issues identified during updating of the following
1413: -- columsn the application_id
1414: -- 1. AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID
1415: -- 2. AMW_CONSTRAINT_ENTRIES.APPLICATION_ID
1416: -- 3. AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID
1417: -- 4. AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID
1418: -- 5. AMW_CONSTRAINT_WAIVERS_B.PK2

Line 1417: -- 4. AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID

1413: -- columsn the application_id
1414: -- 1. AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID
1415: -- 2. AMW_CONSTRAINT_ENTRIES.APPLICATION_ID
1416: -- 3. AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID
1417: -- 4. AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID
1418: -- 5. AMW_CONSTRAINT_WAIVERS_B.PK2
1419: -- Notes
1420: -- this procedure is called in Concurrent Executable
1421: -- ===============================================================

Line 1448: AMW_VIOLAT_USER_ENTRIES avue

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)
1451: AND acv.CONSTRAINT_REV_ID=av.CONSTRAINT_REV_ID
1452: AND av.VIOLATION_ID=avu.VIOLATION_ID

Line 1507: AMW_VIOLAT_USER_ENTRIES avue

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
1510: AND avu.USER_VIOLATION_ID=avue.USER_VIOLATION_ID
1511: AND avue.OBJECT_TYPE='CP'

Line 1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');

1553:
1554: BEGIN
1555: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1556: fnd_file.put_line(fnd_file.LOG,'| |');
1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1558: fnd_file.put_line(fnd_file.LOG,'| |');
1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1560: fnd_file.put_line(fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1561:

Line 1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');

1602: END LOOP;
1603: END IF;
1604: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1605: fnd_file.put_line(fnd_file.LOG,'| |');
1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');

1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');
1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');
1717: fnd_file.put_line(fnd_file.LOG,'| |');
1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1719:
1720: fnd_file.put_line (fnd_file.LOG,'Please Re-Run the violation check for Constraints');

Line 1722: -- Data fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID

1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1719:
1720: fnd_file.put_line (fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1721:
1722: -- Data fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID
1723: -- Clear the List
1724: l_cst_rev_id_list.delete();
1725: l_cst_name_list.delete();
1726: l_function_id_list.delete();

Line 1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');

1764: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1765:
1766: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1767: fnd_file.put_line(fnd_file.LOG,'| |');
1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');
1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');