View: BIS_FLEX_FIELDS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.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