VIEW: APPLSYS.FND_COLUMNS#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, TABLE_ID TABLE_ID, COLUMN_ID COLUMN_ID, COLUMN_NAME COLUMN_NAME, USER_COLUMN_NAME USER_COLUMN_NAME, COLUMN_SEQUENCE COLUMN_SEQUENCE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, COLUMN_TYPE COLUMN_TYPE, WIDTH WIDTH, NULL_ALLOWED_FLAG NULL_ALLOWED_FLAG, TRANSLATE_FLAG TRANSLATE_FLAG, FLEXFIELD_USAGE_CODE FLEXFIELD_USAGE_CODE, DESCRIPTION DESCRIPTION, FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID, FLEXFIELD_NAME FLEXFIELD_NAME, FLEX_VALUE_SET_APPLICATION_ID FLEX_VALUE_SET_APPLICATION_ID, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID, DEFAULT_VALUE DEFAULT_VALUE, PRECISION PRECISION, SCALE SCALE, IREP_COMMENTS IREP_COMMENTS, ZD_EDITION_NAME ZD_EDITION_NAME from "APPLSYS"."FND_COLUMNS"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, TABLE_ID TABLE_ID
, COLUMN_ID COLUMN_ID
, COLUMN_NAME COLUMN_NAME
, USER_COLUMN_NAME USER_COLUMN_NAME
, COLUMN_SEQUENCE COLUMN_SEQUENCE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COLUMN_TYPE COLUMN_TYPE
, WIDTH WIDTH
, NULL_ALLOWED_FLAG NULL_ALLOWED_FLAG
, TRANSLATE_FLAG TRANSLATE_FLAG
, FLEXFIELD_USAGE_CODE FLEXFIELD_USAGE_CODE
, DESCRIPTION DESCRIPTION
, FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, FLEXFIELD_NAME FLEXFIELD_NAME
, FLEX_VALUE_SET_APPLICATION_ID FLEX_VALUE_SET_APPLICATION_ID
, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, DEFAULT_VALUE DEFAULT_VALUE
, PRECISION PRECISION
, SCALE SCALE
, IREP_COMMENTS IREP_COMMENTS
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "APPLSYS"."FND_COLUMNS"