APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 631: SELECT name,csi_item_instance_id FROM AHL_UNIT_CONFIG_HEADERS

627: CURSOR get_max_pk_count IS
628: SELECT (NVL(MAX(visit_ir_uc_id),0) + 1) from ahl_visit_ir_uc_details;
629:
630: CURSOR uc_header_information(c_unit_header_id IN NUMBER) IS
631: SELECT name,csi_item_instance_id FROM AHL_UNIT_CONFIG_HEADERS
632: WHERE unit_config_header_id = c_unit_header_id;
633:
634: CURSOR is_instance_unit(c_instance_id IN NUMBER) IS
635: SELECT 'U' FROM AHL_UNIT_CONFIG_HEADERS WHERE csi_item_instance_id = c_instance_id;

Line 635: SELECT 'U' FROM AHL_UNIT_CONFIG_HEADERS WHERE csi_item_instance_id = c_instance_id;

631: SELECT name,csi_item_instance_id FROM AHL_UNIT_CONFIG_HEADERS
632: WHERE unit_config_header_id = c_unit_header_id;
633:
634: CURSOR is_instance_unit(c_instance_id IN NUMBER) IS
635: SELECT 'U' FROM AHL_UNIT_CONFIG_HEADERS WHERE csi_item_instance_id = c_instance_id;
636:
637: CURSOR get_part_info(c_instance_id NUMBER) IS
638: SELECT MTL.inventory_item_id,MTL.concatenated_segments,CSI.instance_number,CSI.serial_number, CSI.quantity
639: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI