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

Line 201: FROM amw_entity_hierarchies

197: ineffective_sub_orgs =
198: least(greatest(0,ineffective_sub_orgs+l_ineff_diff),sub_orgs_evaluated+l_evaluated_diff,total_sub_orgs)
199: WHERE organization_id IN (
200: SELECT parent_object_id
201: FROM amw_entity_hierarchies
202: START WITH entity_type = 'PROJECT'
203: AND entity_id = l_pk2
204: AND object_type = 'ORG'
205: AND object_id = l_pk1

Line 336: FROM amw_entity_hierarchies hier

332: ) IS
333:
334: CURSOR get_total_sub_orgs IS
335: SELECT count(distinct object_id)
336: FROM amw_entity_hierarchies hier
337: START WITH entity_id = p_audit_project_id
338: AND entity_type = 'PROJECT'
339: AND object_type = 'ORG'
340: AND parent_object_id = p_org_id

Line 354: FROM amw_entity_hierarchies

350: AND object_name = 'AMW_ORGANIZATION'
351: AND pk2_value = p_audit_project_id
352: AND pk1_value IN (
353: SELECT object_id
354: FROM amw_entity_hierarchies
355: START WITH entity_id = p_audit_project_id
356: AND entity_type = 'PROJECT'
357: AND object_type = 'ORG'
358: AND parent_object_id = p_org_id

Line 373: FROM amw_entity_hierarchies

369: AND audit_result_code <> 'EFFECTIVE'
370: AND pk2_value = p_audit_project_id
371: AND pk1_value IN (
372: SELECT object_id
373: FROM amw_entity_hierarchies
374: START WITH entity_id = p_audit_project_id
375: AND entity_type = 'PROJECT'
376: AND object_type = 'ORG'
377: AND parent_object_id = p_org_id