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_TL

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 306: amw_opinion_types_tl optypes,

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

Line 386: amw_opinion_types_tl optypes,

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
390: