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_RISKS_ALL_VL

Line 200: FROM AMW_RISKS_ALL_VL ARAV

196: cursor c_add_risk is
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'

Line 211: FROM AMW_RISKS_ALL_VL ARAV

207: minus
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'

Line 226: FROM AMW_RISKS_ALL_VL ARAV

222: cursor c_delete_risk is
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'

Line 238: FROM AMW_RISKS_ALL_VL ARAV

234: minus
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'

Line 786: FROM AMW_RISKS_ALL_VL ARAV

782: cursor c_add_risk is
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'

Line 798: FROM AMW_RISKS_ALL_VL ARAV

794: minus
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'

Line 812: FROM AMW_RISKS_ALL_VL ARAV

808: cursor c_delete_risk is
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'

Line 825: FROM AMW_RISKS_ALL_VL ARAV

821: minus
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'