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

Line 201: ,AMW_RISK_ASSOCIATIONS ARA

197: (select arav.risk_id
198: ,ARAV.NAME
199: ,ARAV.DESCRIPTION
200: FROM AMW_RISKS_ALL_VL ARAV
201: ,AMW_RISK_ASSOCIATIONS ARA
202: WHERE ARA.RISK_ID=ARAV.RISK_ID
203: AND ARAV.LATEST_REVISION_FLAG='Y'
204: AND ARA.OBJECT_TYPE='PROCESS'
205: AND ARA.DELETION_DATE IS NULL

Line 212: ,AMW_RISK_ASSOCIATIONS ARA

208: (select arav.risk_id
209: ,ARAV.NAME
210: ,ARAV.DESCRIPTION
211: FROM AMW_RISKS_ALL_VL ARAV
212: ,AMW_RISK_ASSOCIATIONS ARA
213: WHERE ARA.RISK_ID=ARAV.RISK_ID
214: AND ARAV.LATEST_REVISION_FLAG='Y'
215: AND ARA.OBJECT_TYPE='PROCESS'
216: AND ARA.APPROVAL_DATE IS not NULL

Line 227: ,AMW_RISK_ASSOCIATIONS ARA

223: (select arav.risk_id
224: ,ARAV.NAME
225: ,ARAV.DESCRIPTION
226: FROM AMW_RISKS_ALL_VL ARAV
227: ,AMW_RISK_ASSOCIATIONS ARA
228: WHERE ARA.RISK_ID=ARAV.RISK_ID
229: AND ARAV.LATEST_REVISION_FLAG='Y'
230: AND ARA.OBJECT_TYPE='PROCESS'
231: AND ARA.APPROVAL_DATE IS not NULL

Line 239: ,AMW_RISK_ASSOCIATIONS ARA

235: (select arav.risk_id
236: ,ARAV.NAME
237: ,ARAV.DESCRIPTION
238: FROM AMW_RISKS_ALL_VL ARAV
239: ,AMW_RISK_ASSOCIATIONS ARA
240: WHERE ARA.RISK_ID=ARAV.RISK_ID
241: AND ARAV.LATEST_REVISION_FLAG='Y'
242: AND ARA.OBJECT_TYPE='PROCESS'
243: AND ARA.DELETION_DATE IS NULL

Line 787: ,AMW_RISK_ASSOCIATIONS ARA

783: (select arav.risk_id
784: ,ARAV.NAME
785: ,ARAV.DESCRIPTION
786: FROM AMW_RISKS_ALL_VL ARAV
787: ,AMW_RISK_ASSOCIATIONS ARA
788: WHERE ARA.RISK_ID=ARAV.RISK_ID
789: AND ARAV.LATEST_REVISION_FLAG='Y'
790: AND ARA.OBJECT_TYPE='PROCESS_ORG'
791: AND ARA.DELETION_DATE IS NULL

Line 799: ,AMW_RISK_ASSOCIATIONS ARA

795: (select arav.risk_id
796: ,ARAV.NAME
797: ,ARAV.DESCRIPTION
798: FROM AMW_RISKS_ALL_VL ARAV
799: ,AMW_RISK_ASSOCIATIONS ARA
800: WHERE ARA.RISK_ID=ARAV.RISK_ID
801: AND ARAV.LATEST_REVISION_FLAG='Y'
802: AND ARA.OBJECT_TYPE='PROCESS_ORG'
803: AND ARA.APPROVAL_DATE IS not NULL

Line 813: ,AMW_RISK_ASSOCIATIONS ARA

809: (select arav.risk_id
810: ,ARAV.NAME
811: ,ARAV.DESCRIPTION
812: FROM AMW_RISKS_ALL_VL ARAV
813: ,AMW_RISK_ASSOCIATIONS ARA
814: WHERE ARA.RISK_ID=ARAV.RISK_ID
815: AND ARAV.LATEST_REVISION_FLAG='Y'
816: AND ARA.OBJECT_TYPE='PROCESS_ORG'
817: AND ARA.APPROVAL_DATE IS not NULL

Line 826: ,AMW_RISK_ASSOCIATIONS ARA

822: (select arav.risk_id
823: ,ARAV.NAME
824: ,ARAV.DESCRIPTION
825: FROM AMW_RISKS_ALL_VL ARAV
826: ,AMW_RISK_ASSOCIATIONS ARA
827: WHERE ARA.RISK_ID=ARAV.RISK_ID
828: AND ARAV.LATEST_REVISION_FLAG='Y'
829: AND ARA.OBJECT_TYPE='PROCESS_ORG'
830: AND ARA.DELETION_DATE IS NULL