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_EVAL_SUM_PVT dependencies on AMW_ENTITY_HIERARCHIES

Line 361: FROM amw_entity_hierarchies ent

357:
358: CURSOR get_certified_sub_orgs
359: IS
360: SELECT count(distinct object_id)
361: FROM amw_entity_hierarchies ent
362: WHERE EXISTS (SELECT opinion.opinion_id
363: FROM amw_opinions_v opinion
364: WHERE opinion.pk1_value = p_org_id
365: AND opinion.pk2_value = p_certification_id

Line 381: FROM amw_entity_hierarchies ent

377:
378: CURSOR get_sub_org_cert_issues
379: IS
380: SELECT count(distinct object_id)
381: FROM amw_entity_hierarchies ent
382: WHERE EXISTS (SELECT opinion.opinion_id
383: FROM amw_opinions_v opinion
384: WHERE opinion.pk1_value = p_org_id
385: AND opinion.pk2_value = p_certification_id

Line 402: FROM amw_entity_hierarchies ent

398:
399: CURSOR get_total_sub_orgs
400: IS
401: SELECT count(distinct object_id)
402: FROM amw_entity_hierarchies ent
403: START WITH parent_object_id = p_org_id
404: AND parent_object_type = 'ORG'
405: AND entity_id = p_certification_id
406: ---07.05.2005 npanandi: add entityType, bugfix 4471783