[Home] [Help] [Dependency Information]
Object Name: | EDW_BRES_PLANT_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.EDW_BRES_PLANT_LCV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the source view that is used to collect plants into the data warehouse. The view is based on HR_ALL_ORGANIZATION_UNITS and MTL_PARAMTERS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_PK | VARCHAR2 | (3) | Unique identifier of the plant | |
ALL_FK | CHAR | (3) | Foreign key to the top most level of the dimension | |
INSTANCE | VARCHAR2 | (30) | Instance from which the record was collected | |
PLANT_DP | VARCHAR2 | (3) | Not currently used | |
NAME | VARCHAR2 | (3) | Plant name | |
ORGANIZATION_NAME | VARCHAR2 | (482) | Name of the organization that owns the plant | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Code of the organization that owns the plant | |
DESCRIPTION | VARCHAR2 | (0) | Plant description | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
OPERATION_CODE | VARCHAR2 | (0) | Operation code | |
USER_ATTRIBUTE1 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (0) | User defined attribute |
Cut, paste (and edit) the following text to query this object:
SELECT PLANT_PK
, ALL_FK
, INSTANCE
, PLANT_DP
, NAME
, ORGANIZATION_NAME
, ORGANIZATION_CODE
, DESCRIPTION
, LAST_UPDATE_DATE
, CREATION_DATE
, OPERATION_CODE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.EDW_BRES_PLANT_LCV;
|
|
|