[Home] [Help] [Dependency Information]
Object Name: | EDW_BRES_RESCAT_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.EDW_BRES_RESCAT_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 resource categories into the data warehouse. It contains all the resource categories, and the organizations they are defined in. The view is based on BOM_RESOURCES and MTL_PARAMETERS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_CATEGORY_PK | VARCHAR2 | (45) | Unique identifier of the resource category | |
INSTANCE | VARCHAR2 | (30) | Instance from which the record was collected | |
PLANT_FK | VARCHAR2 | (6) | Foreign key to the resource category plant level | |
RESOURCE_TYPE_FK | VARCHAR2 | (80) | Foreign key to the resource type level | |
RESOURCE_CATEGORY_DP | VARCHAR2 | (15) | Not currently used | |
NAME | VARCHAR2 | (85) | Resource category name | |
DESCRIPTION | VARCHAR2 | (240) | Resource category description | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | 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 RESOURCE_CATEGORY_PK
, INSTANCE
, PLANT_FK
, RESOURCE_TYPE_FK
, RESOURCE_CATEGORY_DP
, NAME
, DESCRIPTION
, LAST_UPDATE_DATE
, CREATION_DATE
, OPERATION_CODE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.EDW_BRES_RESCAT_LCV;
|
|
|