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_FINSTMT_CERT_MIG_PKG dependencies on AMW_OPINION_M_V

Line 1032: FROM AMW_OPINION_M_V aov

1028: --need check opinion framework doc
1029: --in ap association table, if type = 'CTRL_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=control_id, pk5=opinion_id
1030: CURSOR last_evaluation(l_audit_procedure_id number, l_organization_id number, l_control_id number) IS
1031: SELECT distinct aov.opinion_id
1032: FROM AMW_OPINION_M_V aov
1033: WHERE
1034: aov.object_name = 'AMW_ORG_AP_CONTROL'
1035: AND aov.opinion_type_code = 'EVALUATION'
1036: AND aov.opinion_component_code = 'OVERALL'

Line 1199: AMW_OPINION_M_V aov,

1195:
1196: l_stmt := 'SELECT COUNT(1) FROM
1197: (Select distinct fin.PROCESS_ID, fin.ORGANIZATION_ID
1198: FROM
1199: AMW_OPINION_M_V aov,
1200: amw_fin_cert_scope fin
1201: WHERE aov.OPINION_TYPE_CODE = ''EVALUATION''
1202: and aov.object_name = ''AMW_ORG_PROCESS''
1203: and aov.opinion_component_code = ''OVERALL''

Line 1259: AMW_OPINION_M_V aov,

1255:
1256: l_stmt := 'select count(1) from (
1257: select distinct fin.ORGANIZATION_ID
1258: FROM
1259: AMW_OPINION_M_V aov,
1260: amw_fin_cert_scope fin
1261: WHERE aov.OPINION_TYPE_CODE = ''EVALUATION''
1262: and aov.object_name = ''AMW_ORGANIZATION''
1263: and aov.opinion_component_code = ''OVERALL''

Line 1318: AMW_OPINION_M_V aov,

1314: /*********** replace with the following query that uses opinion_log_id directly
1315: l_stmt := 'select count(1) from (
1316: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
1317: FROM
1318: AMW_OPINION_M_V aov,
1319: amw_fin_item_acc_risk fin
1320: WHERE
1321: aov.OPINION_TYPE_CODE = ''EVALUATION''
1322: and aov.object_name = ''AMW_ORG_PROCESS_RISK''

Line 1334: amw_opinion_m_v aov,

1330:
1331: l_stmt := 'select count(1) from (
1332: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
1333: FROM
1334: amw_opinion_m_v aov,
1335: amw_opinions_log aol,
1336: amw_fin_item_acc_risk fin
1337: WHERE
1338: aov.OPINION_TYPE_CODE = ''EVALUATION''

Line 1400: amw_opinion_m_v aov,

1396:
1397: l_stmt := 'select count(1) from(
1398: select distinct fin.control_id, fin.organization_id
1399: FROM
1400: amw_opinion_m_v aov,
1401: amw_opinions_log aol,
1402: amw_fin_item_acc_ctrl fin
1403: WHERE aov.OPINION_TYPE_CODE = ''EVALUATION''
1404: and aov.object_name = ''AMW_ORG_CONTROL''