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_FIN_COSO_VIEWS_PVT dependencies on AMW_OPINIONS_LOG_V

Line 82: amw_opinions_log_v opinion,

78: distinct
79: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.COMPONENT_CODE
80: from
81: amw_fin_item_acc_ctrl ctrl,
82: amw_opinions_log_v opinion,
83: amw_assessment_components comp,
84: amw_control_associations ctrlAsso
85: where
86: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and

Line 174: amw_opinions_log_v opinion,

170: distinct
171: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.COMPONENT_CODE
172: from
173: amw_fin_item_acc_ctrl ctrl,
174: amw_opinions_log_v opinion,
175: amw_assessment_components comp,
176: amw_control_associations ctrlAsso
177: where
178: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and

Line 211: (SELECT 1 FROM AMW_OPINIONS_LOG_V OPINION

207: AND NATURAL_ACCOUNT_ID = P_ACCOUNT_ID
208: AND CTRL.CONTROL_REV_ID =COMP.OBJECT_ID
209: AND COMP.OBJECT_TYPE ='CONTROL'
210: AND EXISTS
211: (SELECT 1 FROM AMW_OPINIONS_LOG_V OPINION
212: WHERE OPINION.PK1_VALUE = CTRL.CONTROL_ID
213: AND OPINION.PK3_VALUE = CTRL.ORGANIZATION_ID
214: AND OPINION.AUDIT_RESULT_CODE <> 'EFFECTIVE'
215: AND OPINION.OPINION_TYPE_CODE = 'EVALUATION'

Line 256: amw_opinions_log_v opinion,

252: distinct
253: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.COMPONENT_CODE
254: from
255: amw_fin_item_acc_ctrl ctrl,
256: amw_opinions_log_v opinion,
257: amw_assessment_components comp,
258: amw_control_associations ctrlAsso
259: where
260: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID

Line 795: amw_opinions_log_v opinion,

791: distinct
792: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
793: from
794: amw.amw_fin_item_acc_ctrl ctrl,
795: amw_opinions_log_v opinion,
796: amw_control_objectives comp,
797: amw_control_associations ctrlAsso
798: where
799: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and

Line 848: amw_opinions_log_v opinion,

844: distinct
845: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
846: from
847: amw.amw_fin_item_acc_ctrl ctrl,
848: amw_opinions_log_v opinion,
849: amw_control_objectives comp,
850: amw_control_associations ctrlAsso
851: where
852: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID

Line 883: amw_opinions_log_v opinion,

879: distinct
880: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
881: from
882: amw.amw_fin_item_acc_ctrl ctrl,
883: amw_opinions_log_v opinion,
884: amw_control_objectives comp,
885: amw_control_associations ctrlAsso
886: where
887: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and

Line 926: (SELECT 1 FROM AMW_OPINIONS_LOG_V OPINION

922: AND CTRLASSO.PK1 = P_CERTIFICATION_ID
923: AND CTRLASSO.PK2 = CTRL.ORGANIZATION_ID
924: AND CTRLASSO.CONTROL_ID = CTRL.CONTROL_ID
925: AND EXISTS
926: (SELECT 1 FROM AMW_OPINIONS_LOG_V OPINION
927: WHERE
928: OPINION.OPINION_LOG_ID = CTRLASSO.PK5
929: AND OPINION.PK1_VALUE = CTRLASSO.CONTROL_ID
930: AND OPINION.PK3_VALUE = CTRLASSO.PK2

Line 947: amw_opinions_log_v opinion,

943: distinct
944: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
945: from
946: amw.amw_fin_item_acc_ctrl ctrl,
947: amw_opinions_log_v opinion,
948: amw_control_objectives comp,
949: amw_control_associations ctrlAsso
950: where
951: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID

Line 1514: amw_opinions_log_v opinion,

1510: distinct
1511: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
1512: from
1513: amw.amw_fin_item_acc_ctrl ctrl,
1514: amw_opinions_log_v opinion,
1515: amw_control_assertions comp,
1516: amw_control_associations ctrlAsso
1517: where
1518: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and

Line 1606: amw_opinions_log_v opinion,

1602: distinct
1603: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
1604: from
1605: amw.amw_fin_item_acc_ctrl ctrl,
1606: amw_opinions_log_v opinion,
1607: amw_control_assertions comp,
1608: amw_control_associations ctrlAsso
1609: where
1610: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and

Line 1640: (SELECT 1 FROM AMW_OPINIONS_LOG_V OPINION

1636: AND CTRL.ACCOUNT_GROUP_ID = P_ACCOUNT_GROUP_ID
1637: AND NATURAL_ACCOUNT_ID = P_ACCOUNT_ID
1638: AND CTRL.CONTROL_REV_ID = COMP.CONTROL_REV_ID
1639: AND EXISTS
1640: (SELECT 1 FROM AMW_OPINIONS_LOG_V OPINION
1641: WHERE OPINION.PK1_VALUE = CTRL.CONTROL_ID
1642: AND OPINION.PK3_VALUE = CTRL.ORGANIZATION_ID
1643: AND OPINION.AUDIT_RESULT_CODE <> 'EFFECTIVE'
1644: AND OPINION.OPINION_TYPE_CODE = 'EVALUATION'

Line 1686: amw_opinions_log_v opinion,

1682: distinct
1683: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
1684: from
1685: amw.amw_fin_item_acc_ctrl ctrl,
1686: amw_opinions_log_v opinion,
1687: amw_control_assertions comp,
1688: amw_control_associations ctrlAsso
1689: where
1690: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and