Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This view stores the query relates to space restriction information |
Implementation/DBA Data: | APPS.AHL_SPACE_UNAVABL_V |
SELECT ASPL.SPACE_ID
, ASPL.SPACE_NAME
, ASPL.OBJECT_VERSION_NUMBER
, ASPL.BOM_DEPARTMENT_ID
, ASPL.ORGANIZATION_ID
, BDPT.DESCRIPTION DEPT_DESCRIPTION
, HROU.NAME ORG_NAME
, ASPL.SPACE_CATEGORY SPACE_CATEGORY_CODE
, ASCL.MEANING SPACE_CATEGORY_MEAN
, ASPL.INACTIVE_FLAG STATUS_CODE
, ASSL.MEANING STATUS_MEAN
, ASUL.SPACE_UNAVAILABILITY_ID
, ASUL.OBJECT_VERSION_NUMBER
, ASUL.START_DATE
, ASUL.END_DATE
, ASUL.DESCRIPTION
, NULL ORGANIZATION_CODE
FROM AHL_SPACES_VL ASPL
, BOM_DEPARTMENTS BDPT
, HR_ALL_ORGANIZATION_UNITS HROU
, AHL_SPACE_UNAVAILABLE_VL ASUL
, FND_LOOKUP_VALUES_VL ASCL
, FND_LOOKUP_VALUES_VL ASSL
WHERE ASPL.SPACE_ID = ASUL.SPACE_ID
AND ASPL.BOM_DEPARTMENT_ID = BDPT.DEPARTMENT_ID
AND ASPL.ORGANIZATION_ID = HROU.ORGANIZATION_ID
AND ASCL.LOOKUP_TYPE(+) = 'AHL_LTP_SPACE_CATEGORY'
AND ASCL.LOOKUP_CODE(+) = ASPL.SPACE_CATEGORY
AND ASSL.LOOKUP_TYPE(+) = 'AHL_LTP_SPACE_STATUS'
AND ASSL.LOOKUP_CODE(+) = ASPL.INACTIVE_FLAG