[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
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)
2485: pc.removed_instance_id,
2486: pc.mc_relationship_id,
2487: pc.creation_date pc_creation_date
2488: FROM ahl_prd_dispositions_b disp,
2489: ahl_part_changes pc
2490: WHERE disp.part_change_id = pc.part_change_id;
2491: l_pc_dtls get_curr_pc_dtls%ROWTYPE;
2492:
2493: CURSOR get_inst_pc_dtls(c_workorder_id IN NUMBER, c_relationship_id IN NUMBER, c_min_date IN DATE) IS
2492:
2493: CURSOR get_inst_pc_dtls(c_workorder_id IN NUMBER, c_relationship_id IN NUMBER, c_min_date IN DATE) IS
2494: SELECT pc.creation_date,
2495: pc.installed_instance_id
2496: FROM ahl_part_changes pc,
2497: ahl_workorder_operations wop
2498: WHERE pc.workorder_operation_id = wop.workorder_operation_id
2499: AND wop.workorder_id = c_workorder_id
2500: AND pc.mc_relationship_id = c_relationship_id