[Home] [Help]
View: AHL_SPACE_ORG_DETAILS_V
Product: | AHL - Complex Maintenance Repair and Overhaul |
Description: | This view stores the query relates to space restriction information |
Implementation/DBA Data: |
APPS.AHL_SPACE_ORG_DETAILS_V
|
View Text
SELECT ASPL.SPACE_ID
, ASPL.SPACE_NAME
, ASPL.BOM_DEPARTMENT_ID
, ASPL.ORGANIZATION_ID
, BDPT.DESCRIPTION DEPT_DESCRIPTION
, HROU.NAME ORG_NAME
, NULL ORGANIZATION_CODE
FROM AHL_SPACES_VL ASPL
, BOM_DEPARTMENTS BDPT
, HR_ALL_ORGANIZATION_UNITS HROU
WHERE ASPL.BOM_DEPARTMENT_ID = BDPT.DEPARTMENT_ID
AND ASPL.ORGANIZATION_ID = HROU.ORGANIZATION_ID
Columns
Name |
SPACE_ID |
SPACE_NAME |
BOM_DEPARTMENT_ID |
ORGANIZATION_ID |
DEPT_DESCRIPTION |
ORG_NAME |
ORGANIZATION_CODE |