[Home] [Help]
89: WHERE status_code = c_status_code;
90:
91: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 17-Dec-2007
92: -- The OFF and ON quantity for the search UI table needs to be set with the
93: -- newly added columns of the view AHL_PART_CHANGES_V, instead of the instance quantity.
94: CURSOR get_part_change_instance(c_part_change_id NUMBER) IS
95: SELECT OFFC.inventory_item_id off_inv_item_id,
96: OFFI.concatenated_segments off_item_number,
97: OFFC.instance_number off_instance_number,
107: ONC.lot_number on_lot_number,
108: -- ONC.quantity on_quantity,
109: PC.installed_quantity on_quantity,
110: ONC.unit_of_measure on_uom
111: FROM ahl_part_changes_v PC,
112: csi_item_instances OFFC,
113: mtl_system_items_kfv OFFI,
114: csi_item_instances ONC,
115: mtl_system_items_kfv ONI
1141: INC.SUMMARY
1142: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
1143: CS_INCIDENTS_ALL_VL INC,
1144: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE,
1145: AHL_PART_CHANGES_V PC
1146: WHERE disp.path_pos_common_id =pp.path_pos_common_id
1147: AND pp.path_position_id = p_path_position_id
1148: AND disp.part_change_id IS NOT NULL
1149: AND disp.workorder_id = p_workorder_id
1207: CS_INCIDENTS_ALL_B INC,
1208: CS_INCIDENTS_ALL_TL INCL,
1209: CS_INCIDENT_SEVERITIES_TL SEV,
1210: FND_LOOKUP_VALUES PCODE,
1211: AHL_PART_CHANGES_V PC
1212: WHERE pp.path_pos_common_id IN (
1213: SELECT PATH_POS_COMMON_ID
1214: FROM AHL_MC_PATH_POSITIONS
1215: WHERE PATH_POSITION_ID = p_path_position_id
2468: -- is linked with this installation part change id, then this kind of link doesn't
2469: -- make sense and we should break it
2470:
2471: -- Logic of this function simplified by jaramana on 27-FEB-2012 to fix the Perf bug 13775964
2472: -- Removed the use of ahl_part_changes_v
2473: -- Return N only if the Installation Part Change was created after the Disposition's Last Update Date
2474: -- This can happen only if the disp was terminated as otherwise a Disposition's status will be updated
2475: -- after a matching installation is done.
2476: FUNCTION install_part_change_valid(p_disposition_id IN NUMBER)