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.

[Home] [Help]

APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_OBJECT_OPINION_TYPES

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 307: AMW_OBJECT_OPINION_TYPES objoptypes,

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,
310: AMW_PROCESS_ORGANIZATION procorg
311:

Line 387: AMW_OBJECT_OPINION_TYPES objoptypes,

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
390:
391: where procorg.process_id = processtable.process_id

Line 4818: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
4822: opiniontype.OPINION_TYPE_ID = objectopiniontype.OPINION_TYPE_ID AND

Line 4887: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
4891: (Select

Line 4968: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
4972: (Select

Line 5048: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
5052: (Select

Line 5128: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
5132: (Select

Line 5244: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
5248: (Select

Line 5324: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
5328: (Select

Line 5407: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
5411: (Select

Line 5486: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 5577: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 5714: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 5858: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 6045: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
6049: opiniontype.OPINION_TYPE_ID = objectopiniontype.OPINION_TYPE_ID AND

Line 6167: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
6171: (Select

Line 6302: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
6306: (Select

Line 6434: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
6438: (Select

Line 6663: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
6667: (Select

Line 6793: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
6797: (Select

Line 6921: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
6925: (Select

Line 7056: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 7202: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 7442: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 7688: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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

Line 7826: AMW_OBJECT_OPINION_TYPES objectopiniontype,

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
7830: (Select