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_PROCESS_CERT_SUMMARY dependencies on AMW_AUDIT_UNITS_V

Line 929: amw_audit_units_v aauv --03.28.2007 npanandi: bug 5764832 fix -- added join to

925: ---05.24.2005 npanandi: added AmwCertificationB, AmwGlPeriodsV
926: ---in the joins below
927: amw_certification_b acb,
928: amw_gl_periods_v period,
929: amw_audit_units_v aauv --03.28.2007 npanandi: bug 5764832 fix -- added join to
930: --AmwAuditUnitsV to make count consistent with the
931: --'New Risks' added page results
932: ---05.24.2005 npanandi: changed below reference to creationDate
933: ---and added references to ApprovalDate and DeletionApprovalDate resp

Line 964: amw_audit_units_v aauv --03.28.2007 npanandi: bug 5764832 fix -- added join to

960: ---05.24.2005 npanandi: added AmwCertificationB, AmwGlPeriodsV
961: ---in the joins below
962: amw_certification_b acb,
963: amw_gl_periods_v period,
964: amw_audit_units_v aauv --03.28.2007 npanandi: bug 5764832 fix -- added join to
965: --AmwAuditUnitsV to make count consistent with the
966: --'New Controls' added page results
967: ---05.24.2005 npanandi: changed below reference to creationDate
968: ---and added references to ApprovalDate and DeletionApprovalDate resp

Line 1124: AMW_OPINIONS_V aov, amw_audit_units_v aauv /* 03.19.2007 npanandi: bug 5862215 -- only consider those Orgs that are valid*/

1120: SELECT count(1)
1121: FROM (SELECT distinct aes.organization_id, aes.process_id, ara.risk_id
1122: FROM AMW_EXECUTION_SCOPE aes,
1123: AMW_RISK_ASSOCIATIONS ara,
1124: AMW_OPINIONS_V aov, amw_audit_units_v aauv /* 03.19.2007 npanandi: bug 5862215 -- only consider those Orgs that are valid*/
1125: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1126: AND aes.entity_id = p_certification_id
1127: AND aes.level_id > 3
1128: ---AND apo.organization_id = aes.organization_id

Line 1181: AMW_OPINIONS_V aov, amw_audit_units_v aauv /* 03.19.2007 npanandi: bug 5862215: consider only those Orgs that are valid*/

1177: SELECT count(1)
1178: FROM (SELECT distinct aes.organization_id, aca.control_id, aes.process_id /** 01/31/2007 npanandi: added processId in distinct **/
1179: FROM AMW_EXECUTION_SCOPE aes, ---AMW_CURR_APPROVED_REV_ORG_V apo,
1180: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,
1181: AMW_OPINIONS_V aov, amw_audit_units_v aauv /* 03.19.2007 npanandi: bug 5862215: consider only those Orgs that are valid*/
1182: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1183: AND aes.entity_id = p_certification_id
1184: AND aes.level_id > 3
1185: AND ara.object_type = 'PROCESS_ORG'