APPS.WIP_EAMWORKORDER_PVT dependencies on CSI_ITEM_INSTANCES

Line 117: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

113: BEGIN
114:
115: SELECT msib.eam_item_type into l_eam_item_type
116: FROM
117: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
118: WHERE
119: msib.organization_id = mp.organization_id and
120: msib.organization_id = cii.last_vld_organization_id and
121: msib.inventory_item_id = cii.inventory_item_id and

Line 146: csi_item_instances cii

142: INTO
143: l_asset_group_id,
144: l_asset_number
145: FROM
146: csi_item_instances cii
147: WHERE
148: cii.instance_id = p_work_order_rec.maintenance_object_id;
149: l_maintenance_object_type := 3;
150: l_gen_object_id := p_work_order_rec.maintenance_object_id;

Line 158: csi_item_instances cii

154: INTO
155: l_rebuild_item_id,
156: l_rebuild_serial_number
157: FROM
158: csi_item_instances cii
159: WHERE
160: cii.instance_id = p_work_order_rec.maintenance_object_id;
161: l_maintenance_object_type := 3;
162: l_gen_object_id := p_work_order_rec.maintenance_object_id;

Line 176: FROM csi_item_instances

172: IF (l_maint_obj_fnd<>'Y' AND p_work_order_rec.asset_group_id IS NOT NULL AND p_work_order_rec.asset_number IS NOT NULL ) THEN
173: BEGIN
174:
175: SELECT instance_id into l_gen_object_id
176: FROM csi_item_instances
177: WHERE inventory_item_id = p_work_order_rec.asset_group_id and serial_number = p_work_order_rec.asset_number and last_vld_organization_id =p_work_order_rec.organization_id ;
178: l_maintenance_object_type := 3;
179: l_maintenance_object_id := l_gen_object_id;
180: l_maint_obj_fnd :='Y';

Line 191: from csi_item_instances

187: IF (l_maint_obj_fnd<>'Y' AND p_work_order_rec.rebuild_item_id IS NOT NULL
188: AND p_work_order_rec.rebuild_serial_number IS NOT NULL ) THEN
189: BEGIN
190: select instance_id into l_gen_object_id
191: from csi_item_instances
192: where inventory_item_id = p_work_order_rec.rebuild_item_id and serial_number = p_work_order_rec.rebuild_serial_number and last_vld_organization_id =p_work_order_rec.organization_id;
193: l_maintenance_object_type := 3;
194: l_maintenance_object_id := l_gen_object_id;
195: l_maint_obj_fnd :='Y';