[Home] [Help] [Dependency Information]
Object Name: | EDW_BRES_DEPT_CLASS_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.EDW_BRES_DEPT_CLASS_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 department classes into the data warehouse. It contains all the department classes and the organizations they are defined in. The view is based on BOM_DEPARTMENT_CLASSES and MTL_PARAMETERS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPARTMENT_CLASS_PK | VARCHAR2 | (45) | Unique identifier of the department class | |
INSTANCE | VARCHAR2 | (30) | Instance from which the record was collected | |
PLANT_FK | VARCHAR2 | (6) | Foreign key to the plant level | |
DEPARTMENT_CLASS_DP | VARCHAR2 | (85) | Not currently used | |
NAME | VARCHAR2 | (80) | Name of the department class | |
DEPARTMENT_CLASS | VARCHAR2 | (85) | Department Class | |
DESCRIPTION | VARCHAR2 | (240) | Description of the department class | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
OPERATION_CODE | VARCHAR2 | (0) | Code used by the collection program to determine whether to insert/update/delete this record | |
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 DEPARTMENT_CLASS_PK
, INSTANCE
, PLANT_FK
, DEPARTMENT_CLASS_DP
, NAME
, DEPARTMENT_CLASS
, DESCRIPTION
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.EDW_BRES_DEPT_CLASS_LCV;
|
|
|