VIEW: APPS.BIS_FLEX_FIELDS_V

Source

View Text - Preformatted

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$%'
   

View Text - HTML Formatted

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$%'