DBA Data[Home] [Help]

APPS.AMW_LOAD_SOD_DATA dependencies on AMW_VIOLATION_USERS

Line 1447: AMW_VIOLATION_USERS avu,

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

Line 1506: AMW_VIOLATION_USERS avu,

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