DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.EDW_BRES_RESOURCE_LCV

Object Details
Object Name: EDW_BRES_RESOURCE_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.EDW_BRES_RESOURCE_LCV
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.EDW_BRES_RESOURCE_LCV references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_DEPARTMENT_RESOURCES
SynonymBOM_RESOURCES
SynonymCR_RSRC_MST
SynonymEDW_LOCAL_INSTANCE
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS
SynonymWIP_LINES
APPS.EDW_BRES_RESOURCE_LCV is referenced by following:

SchemaAPPS
Package BodyEDW_BOM_RES_M_C - show dependent code