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

Line 379: from amw_control_associations ctrlassoc,

375: Update AMW_PROC_CERT_EVAL_SUM
376: SET INEFFECTIVE_CONTROLS =
377: (select distinct Count(*)
378:
379: from amw_control_associations ctrlassoc,
380: amw_risk_associations riskassoc,
381: amw_process_organization procorg,
382: amw_controls_all_vl controltable,
383: amw_audit_units_v orgtable,

Line 638: FROM AMW_CONTROL_ASSOCIATIONS aca,

634: CURSOR new_controls_added IS
635: SELECT count(1)
636: FROM (
637: SELECT distinct aca.control_id, p_org.organization_id
638: FROM AMW_CONTROL_ASSOCIATIONS aca,
639: AMW_RISK_ASSOCIATIONS ara,
640: AMW_PROCESS_ORGANIZATION apo,
641: AMW_ACCT_ASSOCIATIONS acct_assoc,
642: AMW_PROCESS_ORGANIZATION p_org,

Line 698: FROM AMW_CONTROL_ASSOCIATIONS aca2,

694: AND aca.creation_date >= p_start_date
695: AND aca.object_type = 'RISK_ORG'
696: AND aca.pk1 = ara.risk_association_id
697: AND not exists (SELECT 'Y'
698: FROM AMW_CONTROL_ASSOCIATIONS aca2,
699: AMW_RISK_ASSOCIATIONS ara2
700: WHERE aca2.creation_date < p_start_date
701: AND aca2.object_type = 'RISK_ORG'
702: AND aca2.pk1 = ara2.risk_association_id

Line 1161: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,

1157: SELECT count(1)
1158: FROM (SELECT distinct p_org.organization_id, aca.control_id
1159: FROM AMW_PROCESS_ORGANIZATION apo,
1160: AMW_ACCT_ASSOCIATIONS acct_assoc,
1161: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,
1162: AMW_OPINIONS_V aov,
1163: AMW_PROCESS_ORGANIZATION p_org,
1164: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1165: from Amw_Org_Hierarchy_Denorm

Line 1689: AMW_CONTROL_ASSOCIATIONS aca,

1685: CURSOR ineffective_controls IS
1686: SELECT count(distinct aca.control_id)
1687: FROM AMW_PROCESS_ORGANIZATION apo,
1688: AMW_RISK_ASSOCIATIONS ara,
1689: AMW_CONTROL_ASSOCIATIONS aca,
1690: AMW_OPINIONS_V aov
1691: WHERE apo.organization_id = p_organization_id
1692: AND apo.process_id in ( select distinct(orgrel.child_process_id)
1693: from AMW_PROCESS_ORG_RELATIONS orgrel

Line 2677: AMW_CONTROL_ASSOCIATIONS aca ,

2673: union select process_id, organization_id, process_id, 'D'
2674: from amw_process_organization) hier,
2675: AMW_PROCESS_ORGANIZATION po2,
2676: AMW_RISK_ASSOCIATIONS ara,
2677: AMW_CONTROL_ASSOCIATIONS aca ,
2678: AMW_OPINIONS_V aov
2679: WHERE aa.object_type = 'PROCESS_ORG'
2680: AND po.process_organization_id = aa.pk1
2681: AND hier.organization_id = po.organization_id

Line 2748: AMW_CONTROL_ASSOCIATIONS aca

2744: union select process_id, organization_id, process_id, 'D'
2745: from amw_process_organization) hier,
2746: AMW_PROCESS_ORGANIZATION po2,
2747: AMW_RISK_ASSOCIATIONS ara,
2748: AMW_CONTROL_ASSOCIATIONS aca
2749: WHERE aa.object_type = 'PROCESS_ORG'
2750: AND po.process_organization_id = aa.pk1
2751: AND hier.organization_id = po.organization_id
2752: AND hier.process_id = po.process_id

Line 5489: amw_control_associations ctrlassoc

5485: FND_OBJECTS fndobject,
5486: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5487: amw_process_org_basicinfo_v orgprocess,
5488: amw_risk_associations riskassoc,
5489: amw_control_associations ctrlassoc
5490: WHERE
5491: (opinion.AUTHORED_DATE in
5492: (Select
5493: MAX(opinion2.AUTHORED_DATE)

Line 5805: amw_control_associations ctrlassoc

5801: ( select distinct ctrlassoc.control_id, orgprocess.organization_id
5802: FROM
5803: amw_process_org_basicinfo_v orgprocess,
5804: amw_risk_associations riskassoc,
5805: amw_control_associations ctrlassoc
5806: WHERE
5807: orgprocess.process_organization_id = riskassoc.pk1
5808: and riskassoc.object_type = 'PROCESS_ORG'
5809: and riskassoc.risk_association_id = ctrlassoc.pk1

Line 5861: amw_control_associations ctrlassoc

5857: FND_OBJECTS fndobject,
5858: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5859: amw_process_org_basicinfo_v orgprocess,
5860: amw_risk_associations riskassoc,
5861: amw_control_associations ctrlassoc
5862: WHERE
5863: (opinion.AUTHORED_DATE in
5864: (Select
5865: MAX(opinion2.AUTHORED_DATE)

Line 7059: amw_control_associations ctrlassoc

7055: FND_OBJECTS fndobject,
7056: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7057: amw_process_org_basicinfo_v orgprocess,
7058: amw_risk_associations riskassoc,
7059: amw_control_associations ctrlassoc
7060: WHERE
7061: (opinion.AUTHORED_DATE in
7062: (Select
7063: MAX(opinion2.AUTHORED_DATE)

Line 7585: amw_control_associations ctrlassoc

7581: select distinct ctrlassoc.control_id, orgprocess.organization_id
7582: FROM
7583: amw_process_org_basicinfo_v orgprocess,
7584: amw_risk_associations riskassoc,
7585: amw_control_associations ctrlassoc
7586: WHERE
7587: orgprocess.process_organization_id = riskassoc.pk1
7588: and riskassoc.object_type = 'PROCESS_ORG'
7589: and riskassoc.risk_association_id = ctrlassoc.pk1

Line 7691: amw_control_associations ctrlassoc

7687: FND_OBJECTS fndobject,
7688: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7689: amw_process_org_basicinfo_v orgprocess,
7690: amw_risk_associations riskassoc,
7691: amw_control_associations ctrlassoc
7692: WHERE
7693: (opinion.AUTHORED_DATE in
7694: (Select
7695: MAX(opinion2.AUTHORED_DATE)