134: class_code
135: INTO l_wip_job_rec.rebuild_item_id,
136: l_wip_job_rec.maintenance_object_id,
137: l_wip_job_rec.class_code
138: FROM wip_discrete_jobs
139: WHERE wip_entity_id =
140: ( SELECT wip_entity_id
141: FROM wip_entities
142: WHERE wip_entity_name = p_ahl_wo_rec.wo_name );
1186: WDJ.task_id task_id,
1187: WE.organization_id organization_id,
1188: WE.wip_entity_name wip_entity_name,
1189: WE.entity_type entity_type
1190: FROM wip_discrete_jobs WDJ,
1191: wip_entities WE
1192: WHERE WDJ.wip_entity_id = WE.wip_entity_id
1193: AND WE.wip_entity_id = c_wip_entity_id;
1194: