APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on CSI_ITEM_INSTANCES

Line 222: FROM wip_discrete_jobs wdj,csi_item_instances cii

218: l_inventory_item_id NUMBER;
219:
220: CURSOR cur_work_order_details IS
221: SELECT cii.inventory_item_id
222: FROM wip_discrete_jobs wdj,csi_item_instances cii
223: WHERE wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
224: AND wdj.maintenance_object_type = 3
225: AND wdj.maintenance_object_id = cii.instance_id
226: UNION

Line 523: csi_item_instances cii

519: IF l_maintenance_object_type = 3 THEN
520:
521: SELECT count(*) into l_count
522: FROM wip_discrete_jobs wdj,
523: csi_item_instances cii
524: WHERE wdj.organization_id = cii.last_vld_organization_id
525: AND wdj.maintenance_object_id = cii.instance_id
526: AND wdj.organization_id = p_eam_wo_comp_rec.organization_id
527: AND wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id ;

Line 537: csi_item_instances cii,

533: msn.current_status
534: INTO l_serial_number ,
535: l_serial_status
536: FROM wip_discrete_jobs wdj,
537: csi_item_instances cii,
538: mtl_serial_numbers msn
539: WHERE wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
540: AND wdj.maintenance_object_type = 3
541: AND wdj.maintenance_object_id = cii.instance_id