[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
579: -- End of change by RBHAVSAR for Bug fix 6456199 on Oct 10, 2007
580:
581: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 17-Dec-2007
582: -- For installation against empty positions (typically for non-serialised items),
583: -- fetch the ON quantity directly from the base table ahl_part_changes.
584: ELSE
585: SELECT quantity
586: INTO x_disp_list_tbl(i).on_quantity
587: FROM ahl_part_changes
583: -- fetch the ON quantity directly from the base table ahl_part_changes.
584: ELSE
585: SELECT quantity
586: INTO x_disp_list_tbl(i).on_quantity
587: FROM ahl_part_changes
588: WHERE part_change_id = x_disp_list_tbl(i).part_change_id;
589: END IF;
590:
591: CLOSE get_part_change_instance;
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
2472:
2473: CURSOR get_timestamps IS
2474: SELECT ap.last_update_date, ac.creation_date
2475: FROM ahl_prd_dispositions_b ap,
2476: ahl_part_changes_v pc,
2477: ahl_part_changes ac
2478: WHERE ap.disposition_id = p_disposition_id
2479: AND ap.part_change_id = pc.part_change_id
2480: AND pc.installed_part_change_id = ac.part_change_id;
2473: CURSOR get_timestamps IS
2474: SELECT ap.last_update_date, ac.creation_date
2475: FROM ahl_prd_dispositions_b ap,
2476: ahl_part_changes_v pc,
2477: ahl_part_changes ac
2478: WHERE ap.disposition_id = p_disposition_id
2479: AND ap.part_change_id = pc.part_change_id
2480: AND pc.installed_part_change_id = ac.part_change_id;
2481: l_get_timestamps get_timestamps%ROWTYPE;