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

TABLE: FA.FA_RX_MULTIFORMAT_REPS

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


FA_RX_MULTIFORMAT_REPS stores information about multiple format RXi reports.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_RX_MULTIFORMAT_REPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Unique Request ID of the multiple format report
SUB_REPORT_ID NUMBER
Yes Unique Report ID of one format of a multiple format report
SUB_ATTRIBUTE_SET VARCHAR2 (30)
Attribute set to use for one format of a multiple format report
SUB_REQUEST_ID NUMBER
Yes Request ID of one format of a multiple format report
GROUP_ID NUMBER

Grouping number, used to group together formats within a multiple format report
SEQ_NUMBER NUMBER
Yes Sequence in which the formats should be printed
COMPLEX_FLAG VARCHAR2 (1)
Flag to indicate that formats should be grouped together
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
Query Text

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


SELECT REQUEST_ID
,      SUB_REPORT_ID
,      SUB_ATTRIBUTE_SET
,      SUB_REQUEST_ID
,      GROUP_ID
,      SEQ_NUMBER
,      COMPLEX_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM FA.FA_RX_MULTIFORMAT_REPS;

Dependencies

[top of page]

FA.FA_RX_MULTIFORMAT_REPS does not reference any database object

FA.FA_RX_MULTIFORMAT_REPS is referenced by following:

SchemaFA
ViewFA_RX_MULTIFORMAT_REPS#