[Home] [Help] [Dependency Information]
Object Name: | EDW_BRES_RESOURCE_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.EDW_BRES_RESOURCE_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 routing resources and assembly lines into the data warehouse. It contains all the routing resources and assembly lines, as well as the parent resource category, resource group and department associations. The view is based on BOM_DEPARTMENTS, BOM_RESOURCES, BOM_DEPARTMENT_RESOURCES, MTL_PARAMETERS, WIP_LINES and CR_RSRC_MST.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_PK | VARCHAR2 | (56) | Unique identifier of the resource | |
INSTANCE | VARCHAR2 | (30) | Instance from which the record was collected | |
DEPARTMENT_FK | VARCHAR2 | (50) | Foreign key to the department level | |
RESOURCE_GROUP_FK | VARCHAR2 | (43) | Foreign key to the resource group level | |
RESOURCE_CATEGORY1_FK | VARCHAR2 | (45) | Foreign key to the resource category level in the resource type hierarchy | |
RESOURCE_CATEGORY2_FK | VARCHAR2 | (45) | Foreign key to the resource category level in the resource category hierarchy | |
RESOURCE_DP | VARCHAR2 | (27) | Not currently used | |
NAME | VARCHAR2 | (27) | Resource Name | |
RESOURCE_CODE | VARCHAR2 | (27) | Resource Code | |
DESCRIPTION | VARCHAR2 | (240) | Description of the resource | |
MINIMUM_RATE | NUMBER | Minimum Rate | ||
MAXIMUM_RATE | NUMBER | Maximum Rate | ||
AVAIL_24_HRS_FLAG | VARCHAR2 | (1) | Resource is available 24 Hrs or by shift | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
CREATION_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 RESOURCE_PK
, INSTANCE
, DEPARTMENT_FK
, RESOURCE_GROUP_FK
, RESOURCE_CATEGORY1_FK
, RESOURCE_CATEGORY2_FK
, RESOURCE_DP
, NAME
, RESOURCE_CODE
, DESCRIPTION
, MINIMUM_RATE
, MAXIMUM_RATE
, AVAIL_24_HRS_FLAG
, LAST_UPDATE_DATE
, CREATION_DATE
, OPERATION_CODE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.EDW_BRES_RESOURCE_LCV;
|
|
|