ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE893869E053B46B63588994 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, TASK.TASK_NUMBER, TASK.TASK_NAME, TASK.QUANTITY, TASK.UOM, TASK.MR_NAME MAINTENENCE_REQUIREMENT, TASK.DEPARTMENT_NAME TASK_DEPT_NAME, TASK.STAGE_NAME, TASK.TASK_TYPE_NAME, TASK.TASK_STATUS_NAME, TASK.TASK_WARRANTY_FLAG, TASK.INSTANCE_WARRANTY_FLAG, TASK.CONTRACT_NUMBER WARRANTY_CONTRACT, TASK.ENTITLEMENT_STATUS WARRANTY_STATUS 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 WHERE VISIT.VISIT_NUMBER = :P_VISIT_NUMBER AND VISIT.VISIT_ID = TASK.VISIT_ID 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 ORDER BY VISIT_NUMBER, INSTANCE_NUMBER, TASK_NUMBER Y AHL AHLVITWCR AR AHL تكوين تقرير طبعة الزيارة - عقود ضمانات المهام Application: الصيانة والإصلاح والفحص المعقد Source: تكوين تقرير طبعة الزيارة - عقود ضمانات المهام Short Name: AHLVITWCR DB package: D AHL Auswertung "Überholungsinstanz - Gewährleistungsverträge für Aufgaben" generieren Application: Complex Maintenance Repair and Overhaul Source: Auswertung "Überholungsinstanz - Gewährleistungsverträge für Aufgaben" generieren Short Name: AHLVITWCR DB package: F AHL Générer l'état Instance de visite - Contrats de garantie de tâches Application: Maintenance, réparation et révision complexes Source: Générer l'état Instance de visite - Contrats de garantie de tâches Short Name: AHLVITWCR DB package: US AHL Generate Visit Instance - Tasks Warranty Contracts Application: Complex Maintenance Repair and Overhaul Source: Generate Visit Instance - Tasks Warranty Contracts Report Short Name: AHLVITWCR DB package: ZHS AHL 生成访问例程 - 任务保修合同报表 Application: Complex Maintenance Repair and Overhaul Source: 生成访问例程 - 任务保修合同报表 Short Name: AHLVITWCR DB package: BI Publisher :p_visit_number 1 10 :p_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 访问编号