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.EAM_COMPLETION dependencies on EAM_WO_RELATIONSHIPS

Line 1112: FROM eam_wo_relationships

1108: FROM wip_discrete_jobs
1109: WHERE wip_entity_id IN
1110: (
1111: SELECT DISTINCT child_object_id
1112: FROM eam_wo_relationships
1113: WHERE parent_relationship_type =1
1114: START WITH parent_object_id = x_wip_entity_id AND parent_relationship_type = 1
1115: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1
1116: )

Line 1131: FROM eam_wo_relationships

1127: where wip_entity_id= (SELECT wip_entity_id
1128: FROM wip_discrete_jobs
1129: WHERE wip_entity_id IN
1130: ( SELECT DISTINCT child_object_id
1131: FROM eam_wo_relationships
1132: WHERE parent_relationship_type =1
1133: START WITH parent_object_id = x_wip_entity_id AND parent_relationship_type = 1
1134: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1)
1135: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

Line 1166: FROM eam_wo_relationships

1162: FROM wip_discrete_jobs
1163: WHERE wip_entity_id IN
1164: (
1165: SELECT DISTINCT parent_object_id
1166: FROM eam_wo_relationships
1167: WHERE parent_relationship_type =2 and
1168: child_object_id = x_wip_entity_id
1169: )
1170: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

Line 1184: FROM eam_wo_relationships

1180: where wip_entity_id= (SELECT wip_entity_id
1181: FROM wip_discrete_jobs
1182: WHERE wip_entity_id IN
1183: ( SELECT DISTINCT parent_object_id
1184: FROM eam_wo_relationships
1185: WHERE parent_relationship_type =2 and
1186: child_object_id = x_wip_entity_id
1187: )
1188: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,