Product: | EGO - Advanced Product Catalog |
---|---|
Description: | View contains information for Value Set for table type |
Implementation/DBA Data: | APPS.EGO_VALIDATION_TABLE_INFO_V |
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')