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_WO_NETWORK_VALIDATE_PVT dependencies on MFG_LOOKUPS

Line 1082: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1078:
1079: IF(l_wo_status=17) THEN
1080: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1081: l_WipEntityId_tbl,l_workorder_status_tbl
1082: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1083: WHERE wsr.parent_object_id=p_work_object_id
1084: AND wsr.parent_object_type_id= p_work_object_type_id
1085: AND wsr.child_object_type_id=p_work_object_type_id
1086: AND wsr.child_object_id=wdj.wip_entity_id

Line 1094: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1090: AND lk.lookup_code = wdj.status_type;
1091: ELSIF(l_wo_status=1) THEN
1092: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1093: l_WipEntityId_tbl,l_workorder_status_tbl
1094: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1095: WHERE wsr.parent_object_id=p_work_object_id
1096: AND wsr.parent_object_type_id= p_work_object_type_id
1097: AND wsr.child_object_type_id=p_work_object_type_id
1098: AND wsr.child_object_id=wdj.wip_entity_id

Line 1106: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1102: AND lk.lookup_code = wdj.status_type;
1103: ELSIF(l_wo_status IN (3,6)) THEN
1104: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1105: l_WipEntityId_tbl,l_workorder_status_tbl
1106: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1107: WHERE wsr.parent_object_id=p_work_object_id
1108: AND wsr.parent_object_type_id= p_work_object_type_id
1109: AND wsr.child_object_type_id=p_work_object_type_id
1110: AND wsr.child_object_id=wdj.wip_entity_id

Line 1118: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1114: AND lk.lookup_code = wdj.status_type;
1115: ELSIF(l_wo_status=7) THEN
1116: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1117: l_WipEntityId_tbl,l_workorder_status_tbl
1118: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1119: WHERE wsr.parent_object_id=p_work_object_id
1120: AND wsr.parent_object_type_id= p_work_object_type_id
1121: AND wsr.child_object_type_id=p_work_object_type_id
1122: AND wsr.child_object_id=wdj.wip_entity_id

Line 1130: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1126: AND lk.lookup_code = wdj.status_type;
1127: ELSIF(l_wo_status IN (4,5,12,14,15)) THEN
1128: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1129: l_WipEntityId_tbl,l_workorder_status_tbl
1130: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1131: WHERE wsr.parent_object_id=p_work_object_id
1132: AND wsr.parent_object_type_id= p_work_object_type_id
1133: AND wsr.child_object_type_id=p_work_object_type_id
1134: AND wsr.child_object_id=wdj.wip_entity_id