APPS.EAM_ASSET_LOG_PUB dependencies on CSI_ITEM_INSTANCES

Line 54: FROM csi_item_instances

50: l_organization_id number :=null;
51:
52: CURSOR cresid IS
53: SELECT instance_id, instance_number
54: FROM csi_item_instances
55: WHERE equipment_gen_object_id = nvl(p_equipment_gen_object_id, equipment_gen_object_id) ;
56:
57: CURSOR corgid IS
58: SELECT mp.maint_organization_id

Line 59: FROM csi_item_instances cii, mtl_parameters mp

55: WHERE equipment_gen_object_id = nvl(p_equipment_gen_object_id, equipment_gen_object_id) ;
56:
57: CURSOR corgid IS
58: SELECT mp.maint_organization_id
59: FROM csi_item_instances cii, mtl_parameters mp
60: WHERE cii.equipment_gen_object_id = nvl(p_equipment_gen_object_id, cii.equipment_gen_object_id) AND
61: p_event_date BETWEEN active_start_date AND
62: NVL(active_end_date, SYSDATE) AND
63: cii.last_vld_organization_id = mp.organization_id;

Line 126: FROM csi_item_instances

122: /* For Multiple Record Situation*/
123:
124: BEGIN
125: SELECT 1 INTO l_count
126: FROM csi_item_instances
127: WHERE equipment_gen_object_id = p_equipment_gen_object_id;
128:
129: EXCEPTION
130: WHEN NO_DATA_FOUND THEN