View: AHL_SEARCH_TEMPLATES_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query to retrieve Templates information by search template screen
Implementation/DBA Data:	APPS.AHL_SEARCH_TEMPLATES_V

View Text

SELECT AVTS.VISIT_ID VISIT_ID
, AVTS.VISIT_NUMBER
, AVTS.VISIT_NAME
, AVTS.OBJECT_VERSION_NUMBER
, AVTS.TEMPLATE_FLAG
, AVTS.INVENTORY_ITEM_ID
, AVTS.ITEM_ORGANIZATION_ID
, MTSB.CONCATENATED_SEGMENTS ITEM_DESCRIPTION
, AVTS.VISIT_TYPE_CODE
, FLVT.MEANING VISIT_TYPE_MEAN
, AVTS.LAST_UPDATE_DATE
FROM AHL_VISITS_VL AVTS
, MTL_SYSTEM_ITEMS_B_KFV MTSB
, FND_LOOKUP_VALUES_VL FLVT
WHERE AVTS. INVENTORY_ITEM_ID = MTSB.INVENTORY_ITEM_ID
AND AVTS. ITEM_ORGANIZATION_ID = MTSB.ORGANIZATION_ID
AND FLVT.LOOKUP_TYPE(+) = 'AHL_PLANNING_VISIT_TYPE'
AND FLVT.LOOKUP_CODE(+) = AVTS.VISIT_TYPE_CODE
AND AVTS.TEMPLATE_FLAG = 'Y'

Columns