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_ORG_CERT_AGGR_PKG dependencies on FND_FLEX_VALUES

Line 39: FROM fnd_flex_values flv,

35:
36: -- Get the parent_id and insert a row in the table if appropriate
37: SELECT nvl(flv2.flex_value_id, -1) parent_id
38: INTO l_parent_id
39: FROM fnd_flex_values flv,
40: fnd_flex_value_children_v fchild,
41: fnd_flex_values flv2
42: WHERE fchild.flex_value (+)= flv.flex_value
43: AND fchild.flex_value_set_id (+)= flv.flex_value_set_id

Line 41: fnd_flex_values flv2

37: SELECT nvl(flv2.flex_value_id, -1) parent_id
38: INTO l_parent_id
39: FROM fnd_flex_values flv,
40: fnd_flex_value_children_v fchild,
41: fnd_flex_values flv2
42: WHERE fchild.flex_value (+)= flv.flex_value
43: AND fchild.flex_value_set_id (+)= flv.flex_value_set_id
44: AND flv2.flex_value (+)= fchild.parent_flex_value
45: AND flv2.flex_value_set_id (+)= fchild.flex_value_set_id

Line 123: FROM fnd_flex_values flv,

119: TOP_ORG_PROCESSES,
120: TOP_ORG_PROC_PENDING_CERT,
121: SUB_ORG_CERT_ISSUES,
122: PROC_CERT_ISSUES
123: FROM fnd_flex_values flv,
124: fnd_flex_value_children_v fchild,
125: fnd_flex_values flv_c,
126: amw_org_cert_aggr_sum ocas
127: WHERE flv.flex_value_id = p_subsidiary_id

Line 125: fnd_flex_values flv_c,

121: SUB_ORG_CERT_ISSUES,
122: PROC_CERT_ISSUES
123: FROM fnd_flex_values flv,
124: fnd_flex_value_children_v fchild,
125: fnd_flex_values flv_c,
126: amw_org_cert_aggr_sum ocas
127: WHERE flv.flex_value_id = p_subsidiary_id
128: AND fchild.flex_value_set_id = flv.flex_value_set_id
129: AND fchild.parent_flex_value = flv.flex_value

Line 154: FROM fnd_flex_values flv,

150: TOP_ORG_PROCESSES,
151: TOP_ORG_PROC_PENDING_CERT,
152: SUB_ORG_CERT_ISSUES,
153: PROC_CERT_ISSUES
154: FROM fnd_flex_values flv,
155: hr_organization_information oi,
156: amw_org_cert_eval_sum oces
157: WHERE flv.flex_value_id = p_subsidiary_id
158: AND oi.org_information_context = 'AMW_AUDIT_UNIT'

Line 282: FROM fnd_flex_values flv,

278:
279: -- Get the parent_id and recurse up the hierarchy
280: SELECT nvl(flv2.flex_value_id, -1) parent_id
281: INTO l_parent_id
282: FROM fnd_flex_values flv,
283: fnd_flex_value_children_v fchild,
284: fnd_flex_values flv2
285: WHERE fchild.flex_value (+)= flv.flex_value
286: AND fchild.flex_value_set_id (+)= flv.flex_value_set_id

Line 284: fnd_flex_values flv2

280: SELECT nvl(flv2.flex_value_id, -1) parent_id
281: INTO l_parent_id
282: FROM fnd_flex_values flv,
283: fnd_flex_value_children_v fchild,
284: fnd_flex_values flv2
285: WHERE fchild.flex_value (+)= flv.flex_value
286: AND fchild.flex_value_set_id (+)= flv.flex_value_set_id
287: AND flv2.flex_value (+)= fchild.parent_flex_value
288: AND flv2.flex_value_set_id (+)= fchild.flex_value_set_id

Line 312: fnd_flex_values fv

308: -- select all bottom-level subsidiaries in scope for the certification
309: CURSOR get_all_subs IS
310: SELECT DISTINCT fv.flex_value_id
311: FROM amw_execution_scope es,
312: fnd_flex_values fv
313: WHERE es.entity_type = 'BUSIPROC_CERTIFICATION'
314: AND es.entity_id = p_certification_id
315: AND es.level_id = 3
316: AND fv.flex_value_set_id = es.subsidiary_vs

Line 356: fnd_flex_values fv

352: -- select all bottom-level subsidiaries in scope for the certification
353: CURSOR get_all_subs IS
354: SELECT DISTINCT fv.flex_value_id
355: FROM amw_execution_scope es,
356: fnd_flex_values fv
357: WHERE es.entity_type = 'BUSIPROC_CERTIFICATION'
358: AND es.entity_id = p_certification_id
359: AND es.level_id = 3
360: AND fv.flex_value_set_id = es.subsidiary_vs