DBA Data[Home] [Help] [Dependency Information]

TABLE: FA.FA_RX_DYNAMIC_COLUMNS

Object Details
Object Name: FA_RX_DYNAMIC_COLUMNS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_RX_DYNAMIC_COLUMNS
Subobject Name:
Status: VALID


FA_RX_DYNAMIC_COLUMNS stores dynamic column information for RX
reports.
.
All rows in this table are seeded.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_RX_DYNAMIC_COLUMNS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Request ID
ATTRIBUTE_NAME VARCHAR2 (30) Yes The name of the attribute as it appears to the user in the RX client's download window
COLUMN_NAME VARCHAR2 (30) Yes The name of the interface table column in which this attributes' values are stored
ORDERING VARCHAR2 (15) Yes Ordering of columns
BREAK VARCHAR2 (1)
Determines whether report should break on this column
DISPLAY_LENGTH NUMBER

Display length of column
DISPLAY_FORMAT VARCHAR2 (15) Yes Display format of column
DISPLAY_STATUS VARCHAR2 (15) Yes Display status of column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      ATTRIBUTE_NAME
,      COLUMN_NAME
,      ORDERING
,      BREAK
,      DISPLAY_LENGTH
,      DISPLAY_FORMAT
,      DISPLAY_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM FA.FA_RX_DYNAMIC_COLUMNS;

Dependencies

[top of page]

FA.FA_RX_DYNAMIC_COLUMNS does not reference any database object

FA.FA_RX_DYNAMIC_COLUMNS is referenced by following:

SchemaFA
ViewFA_RX_DYNAMIC_COLUMNS#