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

VIEW: APPS.EDW_OPI_PRDL_PRDL_LCV

Object Details
Object Name: EDW_OPI_PRDL_PRDL_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOPI.EDW_OPI_PRDL_PRDL_LCV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Level source view for the Production Line level of the Production Line dimension.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRDL_PK VARCHAR2 (116)
Primary key on the production line . This is a combination of the production line Identifier, organization Identifier , instance and product-tag.
PRDL_DP VARCHAR2 (10) Yes Discoverer displayed column.
ALL_FK CHAR (3)
Foreign key on the All Level.
NAME VARCHAR2 (10) Yes Displayed name.
PRDL_NAME VARCHAR2 (10) Yes Production line name.
DESCRIPTION VARCHAR2 (240)
Production line description.
ORGN_CODE VARCHAR2 (3)
Organisation code.
USER_ATTRIBUTE1 VARCHAR2 (0)
User Defined Attribute1.
USER_ATTRIBUTE2 VARCHAR2 (0)
User Defined Attribute2.
USER_ATTRIBUTE3 VARCHAR2 (0)
User Defined Attribute3.
USER_ATTRIBUTE4 VARCHAR2 (0)
User Defined Attribute4.
USER_ATTRIBUTE5 VARCHAR2 (0)
User Defined Attribute5.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
CREATION_DATE DATE
Yes Standard WHO column.
Query Text

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


SELECT PRDL_PK
,      PRDL_DP
,      ALL_FK
,      NAME
,      PRDL_NAME
,      DESCRIPTION
,      ORGN_CODE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM APPS.EDW_OPI_PRDL_PRDL_LCV;

Dependencies

[top of page]

APPS.EDW_OPI_PRDL_PRDL_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymMTL_PARAMETERS
SynonymWIP_LINES
APPS.EDW_OPI_PRDL_PRDL_LCV is referenced by following:

SchemaAPPS
ViewEDW_OPI_PRDL_MPV