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

VIEW: APPS.EDW_ITEM_PROD_GRP_LCV

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

View Type

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


This view holds item level product line information


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRODUCT_GROUP_PK NUMBER
Yes Unique identifier for product group
PRODUCT_CATEG_FK NUMBER
Yes Foreign key identifier for Product Category
PRODUCT_GROUP_DP VARCHAR2 (284)
Not currently used
NAME VARCHAR2 (100)
Name
DESCRIPTION VARCHAR2 (240)
Description
SECONDARY_CODE_ID NUMBER
Yes Interest code id
ENABLED_FLAG VARCHAR2 (1)
Enabled Flag
INSTANCE_CODE VARCHAR2 (0)
Instance from which the record was collected
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE

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_GROUP_PK
,      PRODUCT_CATEG_FK
,      PRODUCT_GROUP_DP
,      NAME
,      DESCRIPTION
,      SECONDARY_CODE_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_GRP_LCV;

Dependencies

[top of page]

APPS.EDW_ITEM_PROD_GRP_LCV references the following:

SchemaAPPS
ViewAS_INTEREST_CODES_V
ViewAS_INTEREST_TYPES_V
APPS.EDW_ITEM_PROD_GRP_LCV is referenced by following:

SchemaAPPS
Package BodyEDW_ITEMS_M_C - show dependent code