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 FND_OBJECTS

Line 73: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype

69: -- Fetch the certification result for each next level subprocess
70:
71:
72: select opinion.audit_result INTO l_audit_result
73: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype
74: WHERE
75:
76: (opinion.AUTHORED_DATE in (Select MAX(opinion.AUTHORED_DATE)
77: from AMW_OPINIONS_V opinion

Line 139: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype

135:
136: Update AMW_PROC_CERT_EVAL_SUM
137: SET (CERTIFICATION_OPINION_ID) =
138: (select opinion.OPINION_ID
139: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype
140: WHERE
141:
142: (opinion.AUTHORED_DATE in (Select MAX(AMW_OPINIONS_V.AUTHORED_DATE)
143: from AMW_OPINIONS_V

Line 204: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype

200: Update AMW_PROC_CERT_EVAL_SUM
201: SET ORG_PROCESS_CERT =
202: (
203: select distinct count(*)
204: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype
205: WHERE
206:
207: (opinion.AUTHORED_DATE in (Select MAX(AMW_OPINIONS_V.AUTHORED_DATE)
208: from AMW_OPINIONS_V

Line 256: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype

252: Update AMW_PROC_CERT_EVAL_SUM
253: SET (EVALUATION_OPINION_ID) =
254: (
255: select opinion.OPINION_ID
256: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype
257: WHERE
258:
259: (opinion.AUTHORED_DATE in (Select MAX(AMW_OPINIONS_V.AUTHORED_DATE)
260: from AMW_OPINIONS_V

Line 305: fnd_objects fo,

301: from amw_risk_associations assoctable,
302: amw_risks_all_vl risktable,
303: amw_audit_units_v orgtable,
304: amw_wf_org_hierarchy_main_v processtable,
305: fnd_objects fo,
306: amw_opinion_types_tl optypes,
307: AMW_OBJECT_OPINION_TYPES objoptypes,
308: amw_opinions_v opinionstable,
309: pa_project_lists_v pap,

Line 385: fnd_objects fo,

381: amw_process_organization procorg,
382: amw_controls_all_vl controltable,
383: amw_audit_units_v orgtable,
384: amw_wf_org_hierarchy_main_v processtable,
385: fnd_objects fo,
386: amw_opinion_types_tl optypes,
387: AMW_OBJECT_OPINION_TYPES objoptypes,
388: pa_project_lists_v pap,
389: amw_opinions_v opinionstable

Line 4817: FND_OBJECTS fndobject,

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
4821: opinion.OBJECT_OPINION_TYPE_ID = objectopiniontype.OBJECT_OPINION_TYPE_ID AND

Line 4886: FND_OBJECTS fndobject,

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
4890: (opinion.AUTHORED_DATE in

Line 4967: FND_OBJECTS fndobject,

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
4971: (opinion.AUTHORED_DATE in

Line 5047: FND_OBJECTS fndobject,

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
5051: (opinion.AUTHORED_DATE in

Line 5127: FND_OBJECTS fndobject,

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
5131: (opinion.AUTHORED_DATE in

Line 5243: FND_OBJECTS fndobject,

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
5247: (opinion.AUTHORED_DATE in

Line 5323: FND_OBJECTS fndobject,

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
5327: (opinion.AUTHORED_DATE in

Line 5406: FND_OBJECTS fndobject,

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
5410: (opinion.AUTHORED_DATE in

Line 5485: FND_OBJECTS fndobject,

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,
5489: amw_control_associations ctrlassoc

Line 5576: FND_OBJECTS fndobject,

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
5580: WHERE

Line 5713: FND_OBJECTS fndobject,

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
5717: WHERE

Line 5857: FND_OBJECTS fndobject,

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,
5861: amw_control_associations ctrlassoc

Line 6044: FND_OBJECTS fndobject,

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
6048: opinion.OBJECT_OPINION_TYPE_ID = objectopiniontype.OBJECT_OPINION_TYPE_ID AND

Line 6166: FND_OBJECTS fndobject,

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
6170: (opinion.AUTHORED_DATE in

Line 6301: FND_OBJECTS fndobject,

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
6305: (opinion.AUTHORED_DATE in

Line 6433: FND_OBJECTS fndobject,

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
6437: (opinion.AUTHORED_DATE in

Line 6662: FND_OBJECTS fndobject,

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
6666: (opinion.AUTHORED_DATE in

Line 6792: FND_OBJECTS fndobject,

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
6796: (opinion.AUTHORED_DATE in

Line 6920: FND_OBJECTS fndobject,

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
6924: (opinion.AUTHORED_DATE in

Line 7055: FND_OBJECTS fndobject,

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,
7059: amw_control_associations ctrlassoc

Line 7201: FND_OBJECTS fndobject,

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
7205: WHERE

Line 7441: FND_OBJECTS fndobject,

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
7445: WHERE

Line 7687: FND_OBJECTS fndobject,

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,
7691: amw_control_associations ctrlassoc

Line 7825: FND_OBJECTS fndobject,

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
7829: (opinion.AUTHORED_DATE in