APPS.WIP_EAMWORKORDER_PVT dependencies on CSI_ITEM_INSTANCES

Line 117: csi_item_instances cii

113: INTO
114: l_asset_group_id,
115: l_asset_number
116: FROM
117: csi_item_instances cii
118: WHERE
119: cii.instance_id = p_work_order_rec.maintenance_object_id;
120: l_maintenance_object_type := 3;
121: l_gen_object_id := p_work_order_rec.maintenance_object_id;

Line 133: FROM csi_item_instances

129: 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
130: BEGIN
131:
132: SELECT instance_id into l_gen_object_id
133: FROM csi_item_instances
134: 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 ;
135: l_maintenance_object_type := 3;
136: l_maintenance_object_id := l_gen_object_id;
137: l_maint_obj_fnd :='Y';

Line 148: from csi_item_instances

144: IF (l_maint_obj_fnd<>'Y' AND p_work_order_rec.rebuild_item_id IS NOT NULL
145: AND p_work_order_rec.rebuild_serial_number IS NOT NULL ) THEN
146: BEGIN
147: select instance_id into l_gen_object_id
148: from csi_item_instances
149: 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;
150: l_maintenance_object_type := 3;
151: l_maintenance_object_id := l_gen_object_id;
152: l_maint_obj_fnd :='Y';