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

VIEW: APPS.EDW_BRES_DEPT_LCV

Object Details
Object Name: EDW_BRES_DEPT_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.EDW_BRES_DEPT_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 parent and child departments, as well as assembly lines into the data warehouse. It contains all the departments, and the corresponding department class and parent department associations. It also contains all the assembly lines and the corresponding organization associations. The view is based on BOM_DEPARTMENTS, WIP_LINES and MTL_PARAMETERS.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEPARTMENT_PK VARCHAR2 (50)
Unique Indentifier
INSTANCE VARCHAR2 (30)
Instance from which the record was collected
DEPARTMENT_CLASS_FK VARCHAR2 (45)
Not currently used
PARENT_DEPARTMENT_FK VARCHAR2 (50)
Foreign key to the parent department level
DEPARTMENT_DP VARCHAR2 (96)
Not currently used
NAME VARCHAR2 (96)
Department name
DEPARTMENT_CODE VARCHAR2 (96)
Department code
DESCRIPTION VARCHAR2 (240)
Description
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)
Not currently used
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEPARTMENT_PK
,      INSTANCE
,      DEPARTMENT_CLASS_FK
,      PARENT_DEPARTMENT_FK
,      DEPARTMENT_DP
,      NAME
,      DEPARTMENT_CODE
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      OPERATION_CODE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_BRES_DEPT_LCV;

Dependencies

[top of page]

APPS.EDW_BRES_DEPT_LCV references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymEDW_LOCAL_INSTANCE
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS
SynonymWIP_LINES
APPS.EDW_BRES_DEPT_LCV is referenced by following:

SchemaAPPS
Package BodyEDW_BOM_RES_M_C - show dependent code