VIEW: APPS.AHL_SPACE_CAPBLTS_V

Source

View Text - Preformatted

SELECT DISTINCT(ASPL.SPACE_ID), ASPL.SPACE_NAME, ASPL.BOM_DEPARTMENT_ID, ASPL.OBJECT_VERSION_NUMBER, BDPT.DESCRIPTION DEPT_DESCRIPTION, ASPL.ORGANIZATION_ID, HROU.NAME ORG_NAME, ASPL.SPACE_CATEGORY SPACE_CATEGORY_CODE, ASCL.MEANING SPACE_CATEGORY_MEAN, ASPL.INACTIVE_FLAG STATUS_CODE, ASSL.MEANING STATUS_MEAN, ASCS.SPACE_CAPABILITY_ID, ASCS.OBJECT_VERSION_NUMBER, ASCS.VISIT_TYPE VISIT_TYPE_CODE, ASVL.MEANING VISIT_TYPE_MEAN, ASCS.INVENTORY_ITEM_ID, MTSV.CONCATENATED_SEGMENTS , NULL ORGANIZATION_CODE FROM AHL_SPACES_VL ASPL, BOM_DEPARTMENTS BDPT, HR_ALL_ORGANIZATION_UNITS HROU, AHL_SPACE_CAPABILITIES ASCS, MTL_SYSTEM_ITEMS_B_KFV MTSV, FND_LOOKUP_VALUES_VL ASCL, FND_LOOKUP_VALUES_VL ASVL, FND_LOOKUP_VALUES_VL ASSL WHERE ASPL.SPACE_ID = ASCS.SPACE_ID(+) AND ASPL.BOM_DEPARTMENT_ID = BDPT.DEPARTMENT_ID AND ASPL.ORGANIZATION_ID = HROU.ORGANIZATION_ID AND ASCS.INVENTORY_ITEM_ID = MTSV.INVENTORY_ITEM_ID(+) AND ASCL.LOOKUP_TYPE(+) = 'AHL_LTP_SPACE_CATEGORY' AND ASCL.LOOKUP_CODE(+) = ASPL.SPACE_CATEGORY AND ASVL.LOOKUP_TYPE(+) = 'AHL_PLANNING_VISIT_TYPE' AND ASVL.LOOKUP_CODE(+) = ASCS.VISIT_TYPE AND ASSL.LOOKUP_TYPE(+) = 'AHL_LTP_SPACE_STATUS' AND ASSL.LOOKUP_CODE(+) = ASPL.INACTIVE_FLAG

View Text - HTML Formatted

SELECT DISTINCT(ASPL.SPACE_ID)
, ASPL.SPACE_NAME
, ASPL.BOM_DEPARTMENT_ID
, ASPL.OBJECT_VERSION_NUMBER
, BDPT.DESCRIPTION DEPT_DESCRIPTION
, ASPL.ORGANIZATION_ID
, HROU.NAME ORG_NAME
, ASPL.SPACE_CATEGORY SPACE_CATEGORY_CODE
, ASCL.MEANING SPACE_CATEGORY_MEAN
, ASPL.INACTIVE_FLAG STATUS_CODE
, ASSL.MEANING STATUS_MEAN
, ASCS.SPACE_CAPABILITY_ID
, ASCS.OBJECT_VERSION_NUMBER
, ASCS.VISIT_TYPE VISIT_TYPE_CODE
, ASVL.MEANING VISIT_TYPE_MEAN
, ASCS.INVENTORY_ITEM_ID
, MTSV.CONCATENATED_SEGMENTS
, NULL ORGANIZATION_CODE
FROM AHL_SPACES_VL ASPL
, BOM_DEPARTMENTS BDPT
, HR_ALL_ORGANIZATION_UNITS HROU
, AHL_SPACE_CAPABILITIES ASCS
, MTL_SYSTEM_ITEMS_B_KFV MTSV
, FND_LOOKUP_VALUES_VL ASCL
, FND_LOOKUP_VALUES_VL ASVL
, FND_LOOKUP_VALUES_VL ASSL
WHERE ASPL.SPACE_ID = ASCS.SPACE_ID(+)
AND ASPL.BOM_DEPARTMENT_ID = BDPT.DEPARTMENT_ID
AND ASPL.ORGANIZATION_ID = HROU.ORGANIZATION_ID
AND ASCS.INVENTORY_ITEM_ID = MTSV.INVENTORY_ITEM_ID(+)
AND ASCL.LOOKUP_TYPE(+) = 'AHL_LTP_SPACE_CATEGORY'
AND ASCL.LOOKUP_CODE(+) = ASPL.SPACE_CATEGORY
AND ASVL.LOOKUP_TYPE(+) = 'AHL_PLANNING_VISIT_TYPE'
AND ASVL.LOOKUP_CODE(+) = ASCS.VISIT_TYPE
AND ASSL.LOOKUP_TYPE(+) = 'AHL_LTP_SPACE_STATUS'
AND ASSL.LOOKUP_CODE(+) = ASPL.INACTIVE_FLAG