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

Line 992: FROM amw_entity_hierarchies

988: FROM amw_execution_scope processorg
989: WHERE processorg.process_id = p_process_id
990: AND processorg.organization_id IN
991: (SELECT object_id
992: FROM amw_entity_hierarchies
993: START WITH parent_object_id = p_org_id
994: AND object_type = 'ORG'
995: AND entity_id = p_certification_id
996: AND entity_type='BUSIPROC_CERTIFICATION'

Line 1017: FROM amw_entity_hierarchies

1013: from amw_process
1014: where process_id = p_process_id)
1015: AND scp.organization_id IN
1016: (SELECT object_id
1017: FROM amw_entity_hierarchies
1018: START WITH parent_object_id = p_org_id
1019: AND object_type = 'ORG'
1020: AND entity_id = p_certification_id
1021: AND entity_type='BUSIPROC_CERTIFICATION'

Line 1078: FROM amw_entity_hierarchies

1074: AND aov2.pk3_value = opinion.pk3_value
1075: AND aov2.pk1_value = opinion.pk1_value)
1076: AND opinion.pk3_value IN
1077: (SELECT object_id
1078: FROM amw_entity_hierarchies
1079: START WITH parent_object_id = p_org_id
1080: AND object_type = 'ORG'
1081: AND entity_id = p_certification_id
1082: AND entity_type='BUSIPROC_CERTIFICATION'

Line 1112: FROM amw_entity_hierarchies

1108: from amw_process
1109: where process_id = p_process_id)
1110: AND scp.organization_id IN
1111: (SELECT object_id
1112: FROM amw_entity_hierarchies
1113: START WITH parent_object_id = p_org_id
1114: AND object_type = 'ORG'
1115: AND entity_id = p_certification_id
1116: AND entity_type='BUSIPROC_CERTIFICATION'

Line 1178: FROM amw_entity_hierarchies

1174: AND aov2.pk3_value = opinion.pk3_value
1175: AND aov2.pk1_value = opinion.pk1_value)
1176: AND opinion.pk3_value IN
1177: (SELECT object_id
1178: FROM amw_entity_hierarchies
1179: START WITH parent_object_id = p_org_id
1180: AND object_type = 'ORG'
1181: AND entity_id = p_certification_id
1182: AND entity_type='BUSIPROC_CERTIFICATION'

Line 1220: FROM amw_entity_hierarchies

1216: from amw_process
1217: where process_id = p_process_id)
1218: AND scp.organization_id IN
1219: (SELECT object_id
1220: FROM amw_entity_hierarchies
1221: START WITH parent_object_id = p_org_id
1222: AND object_type = 'ORG'
1223: AND entity_id = p_certification_id
1224: AND entity_type='BUSIPROC_CERTIFICATION'