[Home] [Help]
View: BIS_FLEX_FIELDS_V
View Text
SELECT FA.APPLICATION_ID
, FA.APPLICATION_NAME
, FIF.ID_FLEX_CODE FLEX_FIELD_CODE
, FIF.ID_FLEX_NAME FLEX_FIELD_NAME
, FIF.LAST_UPDATE_DATE
, FIF.LAST_UPDATED_BY
, FIF.LAST_UPDATE_LOGIN
, FIF.CREATED_BY
, FIF.CREATION_DATE
, 'K'
FROM FND_ID_FLEXS FIF
, FND_APPLICATION_VL FA
WHERE FA.APPLICATION_ID = FIF.APPLICATION_ID UNION SELECT FA.APPLICATION_ID
, FA.APPLICATION_NAME
, FDF.DESCRIPTIVE_FLEXFIELD_NAME FLEX_FIELD_CODE
, FDF.TITLE FLEX_FIELD_NAME
, FDF.LAST_UPDATE_DATE
, FDF.LAST_UPDATED_BY
, FDF.LAST_UPDATE_LOGIN
, FDF.CREATED_BY
, FDF.CREATION_DATE
, 'D'
FROM FND_DESCRIPTIVE_FLEXS_VL FDF
, FND_APPLICATION_VL FA
WHERE FA.APPLICATION_ID = FDF.APPLICATION_ID
AND FDF.DESCRIPTIVE_FLEXFIELD_NAME NOT LIKE '$SRS$%'
Columns
Name |
ROW_ID |
APPLICATION_ID |
APPLICATION_NAME |
FLEX_FIELD_CODE |
FLEX_FIELD_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
FLEX_FIELD_TYPE |