ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE8A3869E053B46B63588994Y SELECT VISIT.VISIT_NUMBER, VISIT.VISIT_NAME, UNIT.NAME UNIT_NAME, HROU.NAME ORGANIZATION_NAME, BDPT.DESCRIPTION DEPARTMENT_NAME, VISIT.START_DATE_TIME START_DATE, AHL_VWP_TIMES_PVT.GET_VISIT_END_TIME(VISIT.VISIT_ID) END_DATE, INSTANCE.INSTANCE_NUMBER, INSTANCE.SERIAL_NUMBER, INSTANCE.LOT_NUMBER, ITEM.CONCATENATED_SEGMENTS ITEM_NAME, ITEM.DESCRIPTION ITEM_DESCRIPTION, INSTANCE.ACTIVE_START_DATE SERVICE_ENTRY_DATE, CONTRACT.CONTRACT_NUMBER, FND_STATUS.MEANING CONTRACT_STATUS, CONTRACT.DESCRIPTION CONTRACT_DESC, VENDOR.VENDOR_NAME WARRANTY_VENDOR_NAME, CONTRACT.WARRANTY_PERIOD WARRANTY_PERIOD, UOM.DESCRIPTION CONTRACT_UOM, CONTRACT.ACTIVE_START_DATE CONTRACT_ACTIVE_START_DATE, CONTRACT.EXPIRATION_DATE CONTRACT_EXPIRATION_DATE, COUNTER.NAME CONTRACT_COUNTER_NAME, UOM_CTR.DESCRIPTION CONTRACT_CNTR_UOM_DESC, CONT_CTR.THRESHOLD CONTRACT_CNTR_THRESHOLD, CONT_CTR.START_VALUE CONTRACT_CNTR_START_VALUE, (CONT_CTR.THRESHOLD + CONT_CTR.START_VALUE) STOP_VALUE, CONT_CTR.EXPIRATION_DATE CONTRACT_CNTR_EXPIRATION_DATE FROM MTL_SYSTEM_ITEMS_B_KFV ITEM, AHL_VISITS_VL VISIT, AHL_UNIT_CONFIG_HEADERS UNIT, HR_ALL_ORGANIZATION_UNITS_TL HROU, BOM_DEPARTMENTS BDPT, CSI_ITEM_INSTANCES INSTANCE, AHL_WARRANTY_CONTRACTS_VL CONTRACT, AHL_WARRANTY_CONT_CTR_VL CONT_CTR, FND_LOOKUP_VALUES_VL FND_STATUS, PO_VENDORS VENDOR, MTL_UNITS_OF_MEASURE_VL UOM, CSI_COUNTERS_VL COUNTER, MTL_UNITS_OF_MEASURE_VL UOM_CTR WHERE VISIT.VISIT_NUMBER = :P_VISIT_NUMBER AND UNIT.CSI_ITEM_INSTANCE_ID(+) = VISIT.ITEM_INSTANCE_ID AND VISIT.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND HROU.LANGUAGE(+) = USERENV('LANG') AND VISIT.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND EXISTS (SELECT 'X' FROM AHL_VISIT_TASKS_B TSK WHERE TSK.INSTANCE_ID = INSTANCE.INSTANCE_ID AND TSK.VISIT_ID = VISIT.VISIT_ID) AND ITEM.ORGANIZATION_ID = INSTANCE.INV_MASTER_ORGANIZATION_ID AND ITEM.INVENTORY_ITEM_ID = INSTANCE.INVENTORY_ITEM_ID AND CONTRACT.ITEM_INSTANCE_ID(+) = INSTANCE.INSTANCE_ID AND CONTRACT.WARRANTY_CONTRACT_ID = CONT_CTR.WARRANTY_CONTRACT_ID(+) AND FND_STATUS.LOOKUP_TYPE(+) = 'AHL_WARRANTY_CONT_STATUS' AND FND_STATUS.LOOKUP_CODE(+) = CONTRACT.CONTRACT_STATUS_CODE AND VENDOR.VENDOR_ID (+) = CONTRACT.WARRANTY_VENDOR_ID AND CONTRACT.PERIOD_UOM_CODE = UOM.UOM_CODE(+) AND CONT_CTR.COUNTER_ID = COUNTER.COUNTER_ID (+) AND COUNTER.UOM_CODE = UOM_CTR.UOM_CODE (+) ORDER BY VISIT_NUMBER, INSTANCE_NUMBER AHL AHLVIWCR AR AHL تكوين تقرير عقود ضمانات طبعات الزيارة Application: الصيانة والإصلاح والفحص المعقد Source: تكوين تقرير عقود ضمانات طبعات الزيارة Short Name: AHLVIWCR DB package: D AHL Auswertung "Gewährleistungsverträge für Überholungsinstanzen" generieren Application: Complex Maintenance Repair and Overhaul Source: Auswertung "Gewährleistungsverträge für Überholungsinstanzen" generieren Short Name: AHLVIWCR DB package: F AHL Générer l'état Instances de visite - Contrats de garantie Application: Maintenance, réparation et révision complexes Source: Générer l'état Instances de visite - Contrats de garantie Short Name: AHLVIWCR DB package: US AHL Generate Visit Instances Warranty Contracts Application: Complex Maintenance Repair and Overhaul Source: Generate Visit Instances Warranty Contracts Report Short Name: AHLVIWCR DB package: ZHS AHL 生成访问例程保修合同报表 Application: Complex Maintenance Repair and Overhaul Source: 生成访问例程保修合同报表 Short Name: AHLVIWCR DB package: BI Publisher :p_visit_number 1 10 :warranty visit number LOV Oracle AHL_WARRANTY_VISIT_NUM Y select visit_number id, visit_number value, visit_name description from ahl_visits_vl where visit_id in (select visit_id from ahl_visit_tasks_b task,ahl_warranty_entitlements entl where entl.visit_task_id=task.visit_task_id) and status_code<>'DELETED' order by value,description Y AR رقم الزيارة الخاصة بالضمان D Nummer Überholung gemäß Gewährleistung F Numéro de visite de garantie US Warranty Visit Number ZHS 保修访问编号