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

VIEW: APPS.EDWBV_ITEM_ITEM_LCV

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

View Type

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


This view contains master organization items. It is the base view for its counterpart master organization item collection source view EDW_ITEM_ITEM_LCV. The view is based on the following: MTL_SYSTEM_ITEMS_KFV and MTL_PARAMETERS.


[View Source]

Columns
Name Datatype Length Mandatory Comments
_KF:MSTK:MSTK:_EDW CHAR (16)
Key flexfield tag
ITEM_NUMBER_PK VARCHAR2 (81)
Unique identifier of the item
INSTANCE VARCHAR2 (0)
Instance from which the record was collected
CATSET1_CATEGORY_FK CHAR (6)
Foreign key to the first category level in the first item category hierarchy
CATSET2_CATEGORY_FK CHAR (6)
Foreign key to the first category level in the second item category hierarchy
CATSET3_CATEGORY_FK CHAR (6)
Foreign key to the first category level in the third item category hierarchy
PRODUCT_GROUP_FK CHAR (6)
Foreign key to the product group level
ITEM_NUMBER_DP VARCHAR2 (45)
Not currently used
NAME VARCHAR2 (45)
Item name
ITEM_NAME VARCHAR2 (45)
Item name
DESCRIPTION VARCHAR2 (240)
Item description
ORGANIZATION_ID NUMBER
Yes Internal id of the item's organization
INVENTORY_ITEM_ID NUMBER
Yes Internal id of the item
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
OPERATION_CODE VARCHAR2 (0)
Code used by the collection program to determine whether to insert/update/delete this record
_DF:ITM:_EDW CHAR (28)
Descriptive flexfield tag
ITEM_TYPE VARCHAR2 (30)
Item Type
Query Text

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


SELECT _KF:MSTK:MSTK:_EDW
,      ITEM_NUMBER_PK
,      INSTANCE
,      CATSET1_CATEGORY_FK
,      CATSET2_CATEGORY_FK
,      CATSET3_CATEGORY_FK
,      PRODUCT_GROUP_FK
,      ITEM_NUMBER_DP
,      NAME
,      ITEM_NAME
,      DESCRIPTION
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      OPERATION_CODE
,      _DF:ITM:_EDW
,      ITEM_TYPE
FROM APPS.EDWBV_ITEM_ITEM_LCV;

Dependencies

[top of page]

APPS.EDWBV_ITEM_ITEM_LCV references the following:

SchemaAPPS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
APPS.EDWBV_ITEM_ITEM_LCV is referenced by following:

SchemaAPPS
ViewEDW_ITEM_ITEM_LCV