VIEW: APPS.EGO_VALIDATION_TABLE_INFO_V

Source

View Text - Preformatted

SELECT V_T.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID ,V_T.TABLE_APPLICATION_ID TABLE_APPLICATION_ID ,V_T.APPLICATION_TABLE_NAME APPLICATION_TABLE_NAME ,V_T.VALUE_COLUMN_NAME VALUE_COLUMN_NAME ,V_T.VALUE_COLUMN_TYPE VALUE_COLUMN_TYPE ,V_T.VALUE_COLUMN_SIZE VALUE_COLUMN_SIZE ,V_T.MEANING_COLUMN_NAME MEANING_COLUMN_NAME ,V_T.MEANING_COLUMN_TYPE MEANING_COLUMN_TYPE ,V_T.MEANING_COLUMN_SIZE MEANING_COLUMN_SIZE ,V_T.ID_COLUMN_NAME ID_COLUMN_NAME ,V_T.ID_COLUMN_TYPE ID_COLUMN_TYPE ,V_T.ID_COLUMN_SIZE ID_COLUMN_SIZE ,V_T.ADDITIONAL_WHERE_CLAUSE ADDITIONAL_WHERE_CLAUSE ,F_A.APPLICATION_NAME TABLE_APPLICATION_NAME FROM FND_FLEX_VALIDATION_TABLES V_T ,FND_APPLICATION_TL F_A WHERE F_A.APPLICATION_ID (+) = V_T.TABLE_APPLICATION_ID AND F_A.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT V_T.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, V_T.TABLE_APPLICATION_ID TABLE_APPLICATION_ID
, V_T.APPLICATION_TABLE_NAME APPLICATION_TABLE_NAME
, V_T.VALUE_COLUMN_NAME VALUE_COLUMN_NAME
, V_T.VALUE_COLUMN_TYPE VALUE_COLUMN_TYPE
, V_T.VALUE_COLUMN_SIZE VALUE_COLUMN_SIZE
, V_T.MEANING_COLUMN_NAME MEANING_COLUMN_NAME
, V_T.MEANING_COLUMN_TYPE MEANING_COLUMN_TYPE
, V_T.MEANING_COLUMN_SIZE MEANING_COLUMN_SIZE
, V_T.ID_COLUMN_NAME ID_COLUMN_NAME
, V_T.ID_COLUMN_TYPE ID_COLUMN_TYPE
, V_T.ID_COLUMN_SIZE ID_COLUMN_SIZE
, V_T.ADDITIONAL_WHERE_CLAUSE ADDITIONAL_WHERE_CLAUSE
, F_A.APPLICATION_NAME TABLE_APPLICATION_NAME
FROM FND_FLEX_VALIDATION_TABLES V_T
, FND_APPLICATION_TL F_A
WHERE F_A.APPLICATION_ID (+) = V_T.TABLE_APPLICATION_ID
AND F_A.LANGUAGE (+) = USERENV('LANG')