DBA Data[Home] [Help]

VIEW: APPS.INVFV_DESCRIPTIVE_ELEMENTS

Source

View Text - Preformatted

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
View Text - HTML Formatted

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