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

VIEW: APPS.EDW_ITEM_PROD_LINE_LCV

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

View Type

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


This view holds product line information


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRODUCT_LINE_PK NUMBER
Yes Unique identifier for Product line
ALL_FK CHAR (3)
Foreign key to the 'ALL' level
PRODUCT_LINE_DP VARCHAR2 (80) Yes Not currently used
NAME VARCHAR2 (80)
Product line name
DESCRIPTION VARCHAR2 (240)
Product line description
INTEREST_TYPE_ID NUMBER
Yes Internal id of the interest type
ENABLED_FLAG VARCHAR2 (1)
Enabled flag
INSTANCE_CODE VARCHAR2 (0)
Instance in which the record was collected
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
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
DELETION_DATE DATE

Deletion date
Query Text

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


SELECT PRODUCT_LINE_PK
,      ALL_FK
,      PRODUCT_LINE_DP
,      NAME
,      DESCRIPTION
,      INTEREST_TYPE_ID
,      ENABLED_FLAG
,      INSTANCE_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      DELETION_DATE
FROM APPS.EDW_ITEM_PROD_LINE_LCV;

Dependencies

[top of page]

APPS.EDW_ITEM_PROD_LINE_LCV references the following:

SchemaAPPS
ViewAS_INTEREST_TYPES_V
APPS.EDW_ITEM_PROD_LINE_LCV is referenced by following:

SchemaAPPS
Package BodyEDW_ITEMS_M_C - show dependent code