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.

[Home] [Help]

APPS.AMW_LOAD_SOD_DATA dependencies on AMW_CONSTRAINTS_VL

Line 372: FROM amw_constraints_vl acv, amw_cst_waiver_interface acwi

368: -- the waiver start date should be set to constraint start date if the constraint
369: -- start date is in future or else it is set to the sysdate.
370: CURSOR c_invalid_st_date_batch IS
371: SELECT interface_id, decode(sign(sysdate-acv.start_date),1,sysdate,acv.start_date) start_date
372: FROM amw_constraints_vl acv, amw_cst_waiver_interface acwi
373: WHERE acwi.constraint_name = acv.constraint_name
374: AND acwi.constraint_name IS NOT NULL
375: AND acv.start_date IS NOT NULL
376: AND TRUNC(acwi.start_date)

Line 382: FROM amw_constraints_vl acv, amw_cst_waiver_interface acwi

378: AND (process_flag IS NULL OR process_flag = 'N');
379:
380: CURSOR c_invalid_st_date IS
381: SELECT interface_id, decode(sign(sysdate-acv.start_date),1,sysdate,acv.start_date) start_date
382: FROM amw_constraints_vl acv, amw_cst_waiver_interface acwi
383: WHERE acwi.constraint_name = acv.constraint_name
384: AND acwi.constraint_name IS NOT NULL
385: AND acv.start_date IS NOT NULL
386: AND TRUNC(acwi.start_date)

Line 666: FROM amw_constraints_vl acv

662: with Amw_Constraint_Vl to get the constraint_rev_id from constraint name
663: */
664: UPDATE amw_cst_waiver_interface acwi
665: SET acwi.constraint_rev_id = ( SELECT acv.constraint_rev_id
666: FROM amw_constraints_vl acv
667: WHERE acwi.constraint_name = acv.constraint_name
668: AND acv.start_date IS NOT NULL
669: AND (acv.end_date IS NULL OR acv.end_date>=sysdate))
670: WHERE acwi.batch_id = p_batch_id

Line 687: FROM amw_constraints_vl acv

683: with Amw_Constraint_Vl to get the TYPE_CODE from constraint name
684: */
685: UPDATE amw_cst_waiver_interface acwi
686: SET acwi.type_code = ( SELECT acv.type_code
687: FROM amw_constraints_vl acv
688: WHERE acwi.constraint_rev_id = acv.constraint_rev_id
689: AND acv.start_date IS NOT NULL
690: AND (acv.end_date IS NULL OR acv.end_date>=sysdate))
691: WHERE acwi.batch_id = p_batch_id

Line 1042: FROM amw_constraints_vl acv

1038: with Amw_Constraint_Vl to get the constraint_rev_id from constraint name
1039: */
1040: UPDATE amw_cst_waiver_interface acwi
1041: SET acwi.constraint_rev_id = ( SELECT acv.constraint_rev_id
1042: FROM amw_constraints_vl acv
1043: WHERE acwi.constraint_name = acv.constraint_name
1044: AND acv.start_date IS NOT NULL
1045: AND (acv.end_date IS NULL OR acv.end_date>=sysdate))
1046: WHERE acwi.constraint_name IS NOT NULL

Line 1062: FROM amw_constraints_vl acv

1058: with Amw_Constraint_Vl to get the TYPE_CODE from constraint name
1059: */
1060: UPDATE amw_cst_waiver_interface acwi
1061: SET acwi.type_code = ( SELECT acv.type_code
1062: FROM amw_constraints_vl acv
1063: WHERE acwi.constraint_rev_id = acv.constraint_rev_id
1064: AND acv.start_date IS NOT NULL
1065: AND (acv.end_date IS NULL OR acv.end_date>=sysdate))
1066: WHERE acwi.constraint_name IS NOT NULL

Line 1445: FROM AMW_CONSTRAINTS_VL acv,

1441: CURSOR c_invalid_resp IS
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

Line 1470: FROM AMW_CONSTRAINTS_VL acv,

1466: SELECT acv.CONSTRAINT_REV_ID,
1467: acv.CONSTRAINT_NAME,
1468: ace.OBJECT_TYPE,
1469: ace.FUNCTION_ID
1470: FROM AMW_CONSTRAINTS_VL acv,
1471: AMW_CONSTRAINT_ENTRIES ace
1472: WHERE acv.START_DATE<= SYSDATE
1473: AND (acv.END_DATE IS NULL OR acv.END_DATE>=SYSDATE)
1474: AND acv.CONSTRAINT_REV_ID=ace.CONSTRAINT_REV_ID

Line 1486: FROM AMW_CONSTRAINTS_VL acv,

1482: SELECT acv.CONSTRAINT_REV_ID,
1483: acv.CONSTRAINT_NAME,
1484: ace.OBJECT_TYPE,
1485: ace.FUNCTION_ID
1486: FROM AMW_CONSTRAINTS_VL acv,
1487: AMW_CONSTRAINT_ENTRIES ace
1488: WHERE acv.START_DATE<= SYSDATE
1489: AND (acv.END_DATE IS NULL OR acv.END_DATE>=SYSDATE)
1490: AND acv.CONSTRAINT_REV_ID=ace.CONSTRAINT_REV_ID

Line 1504: FROM AMW_CONSTRAINTS_VL acv,

1500: CURSOR c_valid_amw_vio_user_entries IS
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

Line 1525: AMW_CONSTRAINTS_VL acv,

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
1529: AND av.VIOLATION_ID = avr.VIOLATION_ID

Line 1545: AMW_CONSTRAINTs_VL acv

1541: SELECT acwb.CONSTRAINT_REV_ID,
1542: acv.CONSTRAINT_NAME,
1543: acwb.PK1
1544: FROM AMW_CONSTRAINT_WAIVERS_B acwb,
1545: AMW_CONSTRAINTs_VL acv
1546: WHERE acwb.CONSTRAINT_REV_ID =acv.CONSTRAINT_REV_ID
1547: AND acwb.OBJECT_TYPE='RESP'
1548: AND 1 < ( SELECT COUNT(1)
1549: FROM FND_RESPONSIBILITY resp