[Home] [Help] [Dependency Information]
Object Name: | EDW_BRES_RESTYPE_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.EDW_BRES_RESTYPE_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 types into the data warehouse. The view is based on MFG_LOOKUPS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_TYPE_PK | VARCHAR2 | (80) | Yes | Unique identifier of the resource type |
INSTANCE | VARCHAR2 | (30) | Instance from which the record was collected | |
ALL_FK | CHAR | (3) | Foreign key to the top level of the resource dimension | |
RESOURCE_TYPE_DP | VARCHAR2 | (80) | Not currently used | |
NAME | VARCHAR2 | (80) | Resource type name | |
RESOURCE_TYPE | VARCHAR2 | (80) | Yes | Resource type |
DESCRIPTION | VARCHAR2 | (240) | Resource type 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_TYPE_PK
, INSTANCE
, ALL_FK
, RESOURCE_TYPE_DP
, NAME
, RESOURCE_TYPE
, DESCRIPTION
, LAST_UPDATE_DATE
, CREATION_DATE
, OPERATION_CODE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.EDW_BRES_RESTYPE_LCV;
|
|
|