ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE883869E053B46B63588994Y 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, NVL2(VISIT.UNIT_SCHEDULE_ID,'Yes','No') TRANSIT_VISIT, ITEM.CONCATENATED_SEGMENTS ITEM_NAME, ITEM.DESCRIPTION ITEM_DESCRIPTION, INSTANCE.INSTANCE_NUMBER, INSTANCE.SERIAL_NUMBER, decode(TASK.INSTANCE_WARRANTY_FLAG,'Y','Yes','No') INSTANCE_WARRANTY, TASK.TASK_NUMBER, TASK.TASK_NAME, TASK.MR_NAME, TASK.DEPARTMENT_NAME TASK_DEPT_NAME, TASK.STAGE_NAME, TASK.TASK_TYPE_NAME, TASK.TASK_STATUS_NAME, decode(TASK.TASK_WARRANTY_FLAG,'Y','Yes','No') TASK_WARRANTY_FLAG, TASK.CONTRACT_NUMBER TASK_CONT_NUMBER, NVL(TASK.ENTITLEMENT_STATUS,(SELECT MEANING FROM FND_LOOKUP_VALUES_VL WHERE LOOKUP_TYPE = 'AHL_WARRANTY_ENTLMNT_STATUS' AND LOOKUP_CODE = 'NOT_APPLICABLE')) ENTL_STATUS, NVL(TASK.ENTITLEMENT_STATUS_CODE,'NOT_APPLICABLE') ENTL_STATUS_CODE, TASK.CONTRACT_NUMBER, WTYPE.MEANING WARRANTY_TYPE, CONTRACT.ACTIVE_START_DATE, CONTRACT.ACTIVE_END_DATE, CONTRACT.TERMS_AND_CONDITIONS CONTRACT_TERMS, CONTRACT.REACTION_AND_RESOL_TIME CONTRACT_RESOL, CONTRACT.SERVICE_LEVEL_AGREEMENT CONTRACT_SERVICE, COUNTERS.NAME COUNTER_NAME, COUNTERS.UNIT_OF_MEASURE COUNTER_UOM, CONT_CTR.START_VALUE CONT_CTR_START_VALUE, (CONT_CTR.THRESHOLD + CONT_CTR.START_VALUE) CONT_CTR_STOP_VALUE, CONT_CTR.EXPIRATION_DATE CONT_CTR_EXP_DATE, CONT_CTR.TERMS_AND_CONDITIONS CONT_CTR_TERMS, CONT_CTR.REACTION_AND_RESOL_TIME CONT_CTR_RESOL, CONT_CTR.SERVICE_LEVEL_AGREEMENT CONT_CTR_SERVICE FROM MTL_SYSTEM_ITEMS_B_KFV ITEM, AHL_VISITS_VL VISIT, AHL_UNIT_CONFIG_HEADERS UNIT, AHL_SEARCH_VISIT_TASK_V TASK, 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, CS_COUNTERS_V COUNTERS, FND_LOOKUP_VALUES_VL WTYPE WHERE VISIT.VISIT_ID = TASK.VISIT_ID AND VISIT.VISIT_NUMBER = :P_AHL_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 TASK.INSTANCE_NUMBER = INSTANCE.INSTANCE_NUMBER AND ITEM.INVENTORY_ITEM_ID = TASK.ITEM_ID AND ITEM.ORGANIZATION_ID = TASK.ITEM_ORGANIZATION_ID AND TASK.CONTRACT_NUMBER = CONTRACT.CONTRACT_NUMBER(+) AND CONTRACT.WARRANTY_CONTRACT_ID = CONT_CTR.WARRANTY_CONTRACT_ID(+) AND CONT_CTR.COUNTER_ID = COUNTERS.COUNTER_ID(+) AND WTYPE.LOOKUP_TYPE(+) = 'AHL_WARRANTY_TYPE' AND CONTRACT.WARRANTY_TYPE = WTYPE.LOOKUP_CODE(+) ORDER BY INSTANCE_NUMBER, TASK_NUMBER, COUNTER_NAME AHL AHLSWVR AR AHL تقرير الزيارة الخاص بضمان المورد Application: الصيانة والإصلاح والفحص المعقد Source: تقرير الزيارة الخاص بضمان المورد Short Name: AHLSWVR DB package: D AHL Überholung gemäß Gewährleistung Application: Complex Maintenance Repair and Overhaul Source: Überholung gemäß Gewährleistung Short Name: AHLSWVR DB package: F AHL Etat Visite de garantie fournisseur Application: Maintenance, réparation et révision complexes Source: Etat Visite de garantie fournisseur Short Name: AHLSWVR DB package: US AHL Supplier Warranty Visit Application: Complex Maintenance Repair and Overhaul Source: Supplier Warranty Visit Report Short Name: AHLSWVR DB package: ZHS AHL 供应商保修访问报表 Application: Complex Maintenance Repair and Overhaul Source: 供应商保修访问报表 Short Name: AHLSWVR DB package: BI Publisher :p_ahl_visit_number 1 10 :p_ahl_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 AR رقم الزيارة D Überholungsnummer F Numéro de visite US Visit Number ZHS 访问编号