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_CREATE_LINES_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 253: ,AMW_CONTROL_ASSOCIATIONS aca

249: (select acav.control_id
250: ,acav.NAME
251: ,acav.DESCRIPTION
252: FROM AMW_CONTROLS_ALL_VL acav
253: ,AMW_CONTROL_ASSOCIATIONS aca
254: WHERE aca.control_id=acav.control_id
255: AND acav.LATEST_REVISION_FLAG='Y'
256: AND aca.OBJECT_TYPE='RISK'
257: AND aca.DELETION_DATE IS NULL

Line 264: ,AMW_CONTROL_ASSOCIATIONS aca

260: (select acav.control_id
261: ,acav.NAME
262: ,acav.DESCRIPTION
263: FROM AMW_CONTROLS_ALL_VL acav
264: ,AMW_CONTROL_ASSOCIATIONS aca
265: WHERE aca.control_id=acav.control_id
266: AND acav.LATEST_REVISION_FLAG='Y'
267: AND aca.OBJECT_TYPE='RISK'
268: AND aca.approval_DATE IS not NULL

Line 279: ,AMW_CONTROL_ASSOCIATIONS aca

275: (select acav.control_id
276: ,acav.NAME
277: ,acav.DESCRIPTION
278: FROM AMW_CONTROLS_ALL_VL acav
279: ,AMW_CONTROL_ASSOCIATIONS aca
280: WHERE aca.control_id=acav.control_id
281: AND acav.LATEST_REVISION_FLAG='Y'
282: AND aca.OBJECT_TYPE='RISK'
283: AND aca.approval_DATE IS not NULL

Line 291: ,AMW_CONTROL_ASSOCIATIONS aca

287: (select acav.control_id
288: ,acav.NAME
289: ,acav.DESCRIPTION
290: FROM AMW_CONTROLS_ALL_VL acav
291: ,AMW_CONTROL_ASSOCIATIONS aca
292: WHERE aca.control_id=acav.control_id
293: AND acav.LATEST_REVISION_FLAG='Y'
294: AND aca.OBJECT_TYPE='RISK'
295: AND aca.DELETION_DATE IS NULL

Line 839: ,AMW_CONTROL_ASSOCIATIONS aca

835: (select acav.control_id
836: ,acav.NAME
837: ,acav.DESCRIPTION
838: FROM AMW_CONTROLS_ALL_VL acav
839: ,AMW_CONTROL_ASSOCIATIONS aca
840: WHERE aca.control_id=acav.control_id
841: AND acav.LATEST_REVISION_FLAG='Y'
842: AND aca.OBJECT_TYPE='RISK_ORG'
843: AND aca.DELETION_DATE IS NULL

Line 851: ,AMW_CONTROL_ASSOCIATIONS aca

847: (select acav.control_id
848: ,acav.NAME
849: ,acav.DESCRIPTION
850: FROM AMW_CONTROLS_ALL_VL acav
851: ,AMW_CONTROL_ASSOCIATIONS aca
852: WHERE aca.control_id=acav.control_id
853: AND acav.LATEST_REVISION_FLAG='Y'
854: AND aca.OBJECT_TYPE='RISK_ORG'
855: AND aca.approval_DATE IS not NULL

Line 865: ,AMW_CONTROL_ASSOCIATIONS aca

861: (select acav.control_id
862: ,acav.NAME
863: ,acav.DESCRIPTION
864: FROM AMW_CONTROLS_ALL_VL acav
865: ,AMW_CONTROL_ASSOCIATIONS aca
866: WHERE aca.control_id=acav.control_id
867: AND acav.LATEST_REVISION_FLAG='Y'
868: AND aca.OBJECT_TYPE='RISK_ORG'
869: AND aca.approval_DATE IS not NULL

Line 878: ,AMW_CONTROL_ASSOCIATIONS aca

874: (select acav.control_id
875: ,acav.NAME
876: ,acav.DESCRIPTION
877: FROM AMW_CONTROLS_ALL_VL acav
878: ,AMW_CONTROL_ASSOCIATIONS aca
879: WHERE aca.control_id=acav.control_id
880: AND acav.LATEST_REVISION_FLAG='Y'
881: AND aca.OBJECT_TYPE='RISK_ORG'
882: AND aca.DELETION_DATE IS NULL

Line 892: ,AMW_CONTROL_ASSOCIATIONS ACA

888: SELECT ACAV.CONTROL_ID
889: ,ACAV.NAME
890: ,ACAV.DESCRIPTION
891: FROM AMW_CONTROLS_ALL_VL ACAV
892: ,AMW_CONTROL_ASSOCIATIONS ACA
893: ,(select distinct child_id from
894: amw_latest_hierarchies
895: START WITH CHILD_ID = p_pk2 AND ORGANIZATION_ID = p_pk1
896: CONNECT BY PRIOR CHILD_ID = PARENT_ID

Line 912: ,AMW_CONTROL_ASSOCIATIONS ACA

908: SELECT ACAV.CONTROL_ID
909: ,ACAV.NAME
910: ,ACAV.DESCRIPTION
911: FROM AMW_CONTROLS_ALL_VL ACAV
912: ,AMW_CONTROL_ASSOCIATIONS ACA
913: ,AMW_ORG_HIERARCHY_DENORM AOHD
914: WHERE AOHD.UP_DOWN_IND='D'
915: AND AOHD.ORGANIZATION_ID=ACA.PK1
916: AND AOHD.PARENT_CHILD_ID=ACA.PK2

Line 931: ,AMW_CONTROL_ASSOCIATIONS ACA

927: SELECT ACAV.CONTROL_ID
928: ,ACAV.NAME
929: ,ACAV.DESCRIPTION
930: FROM AMW_CONTROLS_ALL_VL ACAV
931: ,AMW_CONTROL_ASSOCIATIONS ACA
932: WHERE ACA.OBJECT_TYPE='RISK_ORG'
933: AND ACA.DELETION_DATE IS NULL
934: AND ACAV.LATEST_REVISION_FLAG='Y'
935: AND ACAV.CONTROL_ID=ACA.CONTROL_ID