APPS.AMW_LOAD_SOD_DATA dependencies on AMW_VIOLAT_RESP_ENTRIES

Line 1416: -- 3. AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID

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
1419: -- Notes
1420: -- this procedure is called in Concurrent Executable

Line 1527: AMW_VIOLAT_RESP_ENTRIES avre

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
1529: AND av.VIOLATION_ID = avr.VIOLATION_ID
1530: AND avr.RESP_VIOLATION_ID = avre.RESP_VIOLATION_ID
1531: AND avre.OBJECT_TYPE='CP'

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

1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');
1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1775: fnd_file.put_line(fnd_file.LOG,'| |');
1776: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1777:
1778: -- Clear the list

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

1819:
1820:
1821: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1822: fnd_file.put_line(fnd_file.LOG,'| |');
1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');