[Home] [Help]
View: EDW_ITEM_ITEM_LCV
Product: | ENG - Engineering |
Description: | This view holds item level item information |
Implementation/DBA Data: |
APPS.EDW_ITEM_ITEM_LCV
|
View Text
SELECT 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
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ITEM_ITEM_LCV
Columns
Name |
ITEM_NUMBER_PK |
INSTANCE |
INV_CATEGORY_FK |
PO_CATEGORY_FK |
MRP_CATEGORY_FK |
SER_CATEGORY_FK |
CST_CATEGORY_FK |
ENG_CATEGORY_FK |
OE_CATEGORY_FK |
PLA_CATEGORY_FK |
PRODUCT_GROUP_FK |
ITEM_NUMBER_DP |
NAME |
ITEM_NAME |
DESCRIPTION |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
LAST_UPDATE_DATE |
CREATION_DATE |
OPERATION_CODE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |
CATSET1_CATEGORY_FK |
CATSET2_CATEGORY_FK |
CATSET3_CATEGORY_FK |