FND Design Data [Home] [Help]

View: INVFV_DESCRIPTIVE_ELEMENTS

Product: INV - Inventory
Description:
Implementation/DBA Data: ViewAPPS.INVFV_DESCRIPTIVE_ELEMENTS
View Text

SELECT DE.ELEMENT_NAME
, '_KF:INV:MICG:IT'
, DE.ELEMENT_SEQUENCE
, DE.DESCRIPTION
, '_LA:DE.REQUIRED_ELEMENT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:DE.DEFAULT_ELEMENT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, DE.ITEM_CATALOG_GROUP_ID
, DE.LAST_UPDATE_DATE
, DE.LAST_UPDATED_BY
, DE.CREATION_DATE
, DE.CREATED_BY
FROM MTL_ITEM_CATALOG_GROUPS IT
, MTL_DESCRIPTIVE_ELEMENTS DE
WHERE DE.ITEM_CATALOG_GROUP_ID = IT.ITEM_CATALOG_GROUP_ID WITH READ ONLY

Columns

Name
DESCRIPTIVE_ELEMENT_NAME
"_KF:CATALOG_GROUP_NAME"
SEQUENCE_NUMBER
DESCRIPTION
"_LA:REQUIRED_FLAG"
"_LA:DEFAULT_DESCRIPTION_FLAG"
ITEM_CATALOG_GROUP_ID
LAST_UPDATED_DATE
LAST_UPDATED_BY
CREATED_DATE
CREATED_BY