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_FIN_ITEM_ACC_CTRL

Line 81: amw_fin_item_acc_ctrl ctrl,

77: (select
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

Line 113: amw.amw_fin_item_acc_ctrl ctrl,

109: select
110: count(1) numOfCtrls,
111: comp.COMPONENT_CODE
112: from
113: amw.amw_fin_item_acc_ctrl ctrl,
114: amw_assessment_components comp
115: where
116: ctrl.FIN_CERTIFICATION_ID=P_CERTIFICATION_ID and
117: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 136: amw_fin_item_acc_ctrl ctrl,

132: (select
133: distinct
134: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.COMPONENT_CODE
135: from
136: amw_fin_item_acc_ctrl ctrl,
137: amw_opinions_v opinion,
138: amw_assessment_components comp,
139: amw_control_associations ctrlAsso
140: where

Line 173: amw_fin_item_acc_ctrl ctrl,

169: ( select
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

Line 201: FROM AMW_FIN_ITEM_ACC_CTRL CTRL,

197: *********/
198: SELECT COUNT(1) NUMINEFFCTRLS, COMPONENT_CODE
199: FROM
200: (SELECT DISTINCT CTRL.ORGANIZATION_ID, CTRL.CONTROL_ID, COMP.COMPONENT_CODE
201: FROM AMW_FIN_ITEM_ACC_CTRL CTRL,
202: AMW_ASSESSMENT_COMPONENTS COMP
203: WHERE
204: CTRL.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
205: AND CTRL.OBJECT_TYPE = 'ACCOUNT'

Line 234: amw.amw_fin_item_acc_ctrl ctrl,

230: select
231: count(1) numOfCtrls,
232: comp.COMPONENT_CODE
233: from
234: amw.amw_fin_item_acc_ctrl ctrl,
235: amw_assessment_components comp
236: where
237: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
238: ctrl.OBJECT_TYPE = 'ACCOUNT' and

Line 255: amw_fin_item_acc_ctrl ctrl,

251: ( select
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

Line 794: amw.amw_fin_item_acc_ctrl ctrl,

790: (select
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

Line 825: amw.amw_fin_item_acc_ctrl ctrl,

821: select
822: count(1) numOfCtrls,
823: comp.OBJECTIVE_CODE
824: from
825: amw.amw_fin_item_acc_ctrl ctrl,
826: amw_control_objectives comp
827: where
828: ctrl.FIN_CERTIFICATION_ID=P_CERTIFICATION_ID and
829: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 847: amw.amw_fin_item_acc_ctrl ctrl,

843: (select
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

Line 882: amw.amw_fin_item_acc_ctrl ctrl,

878: (select
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

Line 909: FROM AMW.AMW_FIN_ITEM_ACC_CTRL CTRL,

905: ****/
906: SELECT COUNT(1) NUMINEFFCTRLS, OBJECTIVE_CODE
907: FROM
908: (SELECT DISTINCT CTRL.ORGANIZATION_ID, CTRL.CONTROL_ID, COMP.OBJECTIVE_CODE
909: FROM AMW.AMW_FIN_ITEM_ACC_CTRL CTRL,
910: AMW_CONTROL_OBJECTIVES COMP
911: WHERE
912: CTRL.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
913: AND CTRL.OBJECT_TYPE = 'ACCOUNT'

Line 946: amw.amw_fin_item_acc_ctrl ctrl,

942: (select
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

Line 976: amw.amw_fin_item_acc_ctrl ctrl,

972: select
973: count(1) numOfCtrls,
974: comp.OBJECTIVE_CODE
975: from
976: amw.amw_fin_item_acc_ctrl ctrl,
977: amw_control_objectives comp
978: where
979: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
980: ctrl.OBJECT_TYPE = 'ACCOUNT' and

Line 1513: amw.amw_fin_item_acc_ctrl ctrl,

1509: (select
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

Line 1548: amw.amw_fin_item_acc_ctrl ctrl,

1544: (select
1545: distinct
1546: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
1547: from
1548: amw.amw_fin_item_acc_ctrl ctrl,
1549: amw_opinions_v opinion,
1550: amw_control_assertions comp,
1551: amw_control_associations ctrlAsso
1552: where

Line 1578: amw.amw_fin_item_acc_ctrl ctrl,

1574: select
1575: count(1) numOfCtrls,
1576: comp.ASSERTION_CODE
1577: from
1578: amw.amw_fin_item_acc_ctrl ctrl,
1579: amw_control_assertions comp
1580: where
1581: ctrl.FIN_CERTIFICATION_ID=P_CERTIFICATION_ID and
1582: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 1605: amw.amw_fin_item_acc_ctrl ctrl,

1601: (select
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

Line 1632: FROM AMW.AMW_FIN_ITEM_ACC_CTRL CTRL, AMW_CONTROL_ASSERTIONS COMP

1628: ***/
1629: SELECT COUNT(1) NUMINEFFCTRLS, ASSERTION_CODE
1630: FROM
1631: (SELECT DISTINCT CTRL.ORGANIZATION_ID, CTRL.CONTROL_ID, COMP.ASSERTION_CODE
1632: FROM AMW.AMW_FIN_ITEM_ACC_CTRL CTRL, AMW_CONTROL_ASSERTIONS COMP
1633: WHERE
1634: CTRL.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
1635: AND CTRL.OBJECT_TYPE = 'ACCOUNT'
1636: AND CTRL.ACCOUNT_GROUP_ID = P_ACCOUNT_GROUP_ID

Line 1663: amw.amw_fin_item_acc_ctrl ctrl,

1659: select
1660: count(1) numOfCtrls,
1661: comp.ASSERTION_CODE
1662: from
1663: amw.amw_fin_item_acc_ctrl ctrl,
1664: amw_control_assertions comp
1665: where
1666: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
1667: ctrl.OBJECT_TYPE = 'ACCOUNT' and

Line 1685: amw.amw_fin_item_acc_ctrl ctrl,

1681: (select
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

Line 3069: amw.amw_fin_item_acc_ctrl ctrl,

3065: select
3066: distinct
3067: comp.COMPONENT_CODE
3068: from
3069: amw.amw_fin_item_acc_ctrl ctrl,
3070: amw_assessment_components comp
3071: where
3072: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
3073: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 3384: amw.amw_fin_item_acc_ctrl ctrl,

3380: is select
3381: distinct
3382: comp.COMPONENT_CODE
3383: from
3384: amw.amw_fin_item_acc_ctrl ctrl,
3385: amw_assessment_components comp
3386: where
3387: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
3388: and

Line 3744: amw.amw_fin_item_acc_ctrl ctrl,

3740: select
3741: distinct
3742: comp.OBJECTIVE_CODE
3743: from
3744: amw.amw_fin_item_acc_ctrl ctrl,
3745: amw_control_objectives comp
3746: where
3747: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
3748: and

Line 4111: amw.amw_fin_item_acc_ctrl ctrl,

4107: select
4108: distinct
4109: comp.OBJECTIVE_CODE
4110: from
4111: amw.amw_fin_item_acc_ctrl ctrl,
4112: amw_control_objectives comp
4113: where
4114: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
4115: and

Line 4500: amw.amw_fin_item_acc_ctrl ctrl,

4496: select
4497: distinct
4498: comp.ASSERTION_CODE
4499: from
4500: amw.amw_fin_item_acc_ctrl ctrl,
4501: amw_control_assertions comp
4502: where
4503: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
4504: and

Line 4992: amw.amw_fin_item_acc_ctrl ctrl,

4988: select
4989: distinct
4990: comp.ASSERTION_CODE
4991: from
4992: amw.amw_fin_item_acc_ctrl ctrl,
4993: amw_control_assertions comp
4994: where
4995: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
4996: and