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_OPINION_TYPES_B

Line 4816: AMW_OPINION_TYPES_B opiniontype,

4812: (
4813: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
4814: FROM
4815: AMW_OPINIONS_V opinion,
4816: AMW_OPINION_TYPES_B opiniontype,
4817: FND_OBJECTS fndobject,
4818: AMW_OBJECT_OPINION_TYPES objectopiniontype,
4819: amw_process_org_basicinfo_v orgprocess
4820: WHERE

Line 4885: AMW_OPINION_TYPES_B opiniontype,

4881: (
4882: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
4883: FROM
4884: AMW_OPINIONS_V opinion,
4885: AMW_OPINION_TYPES_B opiniontype,
4886: FND_OBJECTS fndobject,
4887: AMW_OBJECT_OPINION_TYPES objectopiniontype,
4888: amw_process_org_basicinfo_v orgprocess
4889: WHERE

Line 4966: AMW_OPINION_TYPES_B opiniontype,

4962: from (
4963: select distinct orgprocess.ORGANIZATION_ID
4964: FROM
4965: AMW_OPINIONS_V opinion,
4966: AMW_OPINION_TYPES_B opiniontype,
4967: FND_OBJECTS fndobject,
4968: AMW_OBJECT_OPINION_TYPES objectopiniontype,
4969: amw_process_org_basicinfo_v orgprocess
4970: WHERE

Line 5046: AMW_OPINION_TYPES_B opiniontype,

5042: (
5043: select distinct orgprocess.ORGANIZATION_ID
5044: FROM
5045: AMW_OPINIONS_V opinion,
5046: AMW_OPINION_TYPES_B opiniontype,
5047: FND_OBJECTS fndobject,
5048: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5049: amw_process_org_basicinfo_v orgprocess
5050: WHERE

Line 5126: AMW_OPINION_TYPES_B opiniontype,

5122: (
5123: select distinct orgprocess.ORGANIZATION_ID
5124: FROM
5125: AMW_OPINIONS_V opinion,
5126: AMW_OPINION_TYPES_B opiniontype,
5127: FND_OBJECTS fndobject,
5128: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5129: amw_process_org_basicinfo_v orgprocess
5130: WHERE

Line 5242: AMW_OPINION_TYPES_B opiniontype,

5238: (
5239: select distinct orgprocess.ORGANIZATION_ID
5240: FROM
5241: AMW_OPINIONS_V opinion,
5242: AMW_OPINION_TYPES_B opiniontype,
5243: FND_OBJECTS fndobject,
5244: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5245: amw_process_org_basicinfo_v orgprocess
5246: WHERE

Line 5322: AMW_OPINION_TYPES_B opiniontype,

5318: from (
5319: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
5320: FROM
5321: AMW_OPINIONS_V opinion,
5322: AMW_OPINION_TYPES_B opiniontype,
5323: FND_OBJECTS fndobject,
5324: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5325: amw_process_org_basicinfo_v orgprocess
5326: WHERE

Line 5405: AMW_OPINION_TYPES_B opiniontype,

5401: (
5402: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
5403: FROM
5404: AMW_OPINIONS_V opinion,
5405: AMW_OPINION_TYPES_B opiniontype,
5406: FND_OBJECTS fndobject,
5407: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5408: amw_process_org_basicinfo_v orgprocess
5409: WHERE

Line 5484: AMW_OPINION_TYPES_B opiniontype,

5480: from (
5481: select distinct ctrlassoc.control_id, orgprocess.organization_id
5482: FROM
5483: AMW_OPINIONS_V opinion,
5484: AMW_OPINION_TYPES_B opiniontype,
5485: FND_OBJECTS fndobject,
5486: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5487: amw_process_org_basicinfo_v orgprocess,
5488: amw_risk_associations riskassoc,

Line 5575: AMW_OPINION_TYPES_B opiniontype,

5571: count(1) into p_unmitigated_risks
5572: from (select distinct riskassoc.risk_id ,orgprocess.organization_id, orgprocess.Process_ID
5573: FROM
5574: AMW_OPINIONS_V opinion,
5575: AMW_OPINION_TYPES_B opiniontype,
5576: FND_OBJECTS fndobject,
5577: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5578: amw_process_org_basicinfo_v orgprocess,
5579: amw_risk_associations riskassoc

Line 5712: AMW_OPINION_TYPES_B opiniontype,

5708: count(1) into p_risks_verified
5709: from (select distinct riskassoc.risk_id ,orgprocess.organization_id, orgprocess.Process_ID
5710: FROM
5711: AMW_OPINIONS_V opinion,
5712: AMW_OPINION_TYPES_B opiniontype,
5713: FND_OBJECTS fndobject,
5714: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5715: amw_process_org_basicinfo_v orgprocess,
5716: amw_risk_associations riskassoc

Line 5856: AMW_OPINION_TYPES_B opiniontype,

5852: FROM
5853: (select distinct ctrlassoc.control_id, orgprocess.organization_id
5854: FROM
5855: AMW_OPINIONS_V opinion,
5856: AMW_OPINION_TYPES_B opiniontype,
5857: FND_OBJECTS fndobject,
5858: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5859: amw_process_org_basicinfo_v orgprocess,
5860: amw_risk_associations riskassoc,

Line 6043: AMW_OPINION_TYPES_B opiniontype,

6039: select count(1) into P_PROCS_IN_CERTIFICATION from (
6040: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
6041: FROM
6042: AMW_OPINIONS_V opinion,
6043: AMW_OPINION_TYPES_B opiniontype,
6044: FND_OBJECTS fndobject,
6045: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6046: amw_process_org_basicinfo_v orgprocess
6047: WHERE

Line 6165: AMW_OPINION_TYPES_B opiniontype,

6161: select count(1) into P_PROCS_EVALUATED from (
6162: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
6163: FROM
6164: AMW_OPINIONS_V opinion,
6165: AMW_OPINION_TYPES_B opiniontype,
6166: FND_OBJECTS fndobject,
6167: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6168: amw_process_org_basicinfo_v orgprocess
6169: WHERE

Line 6300: AMW_OPINION_TYPES_B opiniontype,

6296: select count(1) into P_PROC_CERTIFIED_WITH_ISSUES from (
6297: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
6298: FROM
6299: AMW_OPINIONS_V opinion,
6300: AMW_OPINION_TYPES_B opiniontype,
6301: FND_OBJECTS fndobject,
6302: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6303: amw_process_org_basicinfo_v orgprocess
6304: WHERE

Line 6432: AMW_OPINION_TYPES_B opiniontype,

6428: select count(1) into P_org_with_ineffective_ctrls from (
6429: select distinct orgprocess.ORGANIZATION_ID
6430: FROM
6431: AMW_OPINIONS_V opinion,
6432: AMW_OPINION_TYPES_B opiniontype,
6433: FND_OBJECTS fndobject,
6434: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6435: amw_process_org_basicinfo_v orgprocess
6436: WHERE

Line 6661: AMW_OPINION_TYPES_B opiniontype,

6657: select count(1) into P_org_evaluated from (
6658: select distinct orgprocess.ORGANIZATION_ID
6659: FROM
6660: AMW_OPINIONS_V opinion,
6661: AMW_OPINION_TYPES_B opiniontype,
6662: FND_OBJECTS fndobject,
6663: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6664: amw_process_org_basicinfo_v orgprocess
6665: WHERE

Line 6791: AMW_OPINION_TYPES_B opiniontype,

6787: select
6788: distinct orgprocess.ORGANIZATION_ID
6789: FROM
6790: AMW_OPINIONS_V opinion,
6791: AMW_OPINION_TYPES_B opiniontype,
6792: FND_OBJECTS fndobject,
6793: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6794: amw_process_org_basicinfo_v orgprocess
6795: WHERE

Line 6919: AMW_OPINION_TYPES_B opiniontype,

6915: select count(1) into P_proc_with_ineffective_ctrls from (
6916: Select distinct orgprocess.PROCESS_ID, orgprocess.ORGANIZATION_ID
6917: FROM
6918: AMW_OPINIONS_V opinion,
6919: AMW_OPINION_TYPES_B opiniontype,
6920: FND_OBJECTS fndobject,
6921: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6922: amw_process_org_basicinfo_v orgprocess
6923: WHERE

Line 7054: AMW_OPINION_TYPES_B opiniontype,

7050: select count(1) into p_ineffective_controls from(
7051: select distinct ctrlassoc.control_id, orgprocess.organization_id
7052: FROM
7053: AMW_OPINIONS_V opinion,
7054: AMW_OPINION_TYPES_B opiniontype,
7055: FND_OBJECTS fndobject,
7056: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7057: amw_process_org_basicinfo_v orgprocess,
7058: amw_risk_associations riskassoc,

Line 7200: AMW_OPINION_TYPES_B opiniontype,

7196: select count(1) into p_unmitigated_risks from (
7197: select distinct riskassoc.risk_id ,orgprocess.organization_id, orgprocess.Process_ID
7198: FROM
7199: AMW_OPINIONS_V opinion,
7200: AMW_OPINION_TYPES_B opiniontype,
7201: FND_OBJECTS fndobject,
7202: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7203: amw_process_org_basicinfo_v orgprocess,
7204: amw_risk_associations riskassoc

Line 7440: AMW_OPINION_TYPES_B opiniontype,

7436: select count(1) into p_risks_verified from (
7437: select distinct riskassoc.risk_id ,orgprocess.organization_id, orgprocess.Process_ID
7438: FROM
7439: AMW_OPINIONS_V opinion,
7440: AMW_OPINION_TYPES_B opiniontype,
7441: FND_OBJECTS fndobject,
7442: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7443: amw_process_org_basicinfo_v orgprocess,
7444: amw_risk_associations riskassoc

Line 7686: AMW_OPINION_TYPES_B opiniontype,

7682: select count(1) into p_controls_verified from (
7683: select distinct ctrlassoc.control_id, orgprocess.organization_id
7684: FROM
7685: AMW_OPINIONS_V opinion,
7686: AMW_OPINION_TYPES_B opiniontype,
7687: FND_OBJECTS fndobject,
7688: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7689: amw_process_org_basicinfo_v orgprocess,
7690: amw_risk_associations riskassoc,

Line 7824: AMW_OPINION_TYPES_B opiniontype,

7820: select count(1) into P_org_cert_with_issues from (
7821: select distinct orgprocess.ORGANIZATION_ID
7822: FROM
7823: AMW_OPINIONS_V opinion,
7824: AMW_OPINION_TYPES_B opiniontype,
7825: FND_OBJECTS fndobject,
7826: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7827: amw_process_org_basicinfo_v orgprocess
7828: WHERE