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

TABLE: APPLSYS.FND_CONC_REQ_OUTPUTS

Object Details
Object Name: FND_CONC_REQ_OUTPUTS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_CONC_REQ_OUTPUTS
Subobject Name:
Status: VALID


This table stores output files created by Concurrent Request. Initial
output file generated by Concurrent Request will be stored in
FND_CONCURRENT_REQUESTS table and all remaining output files generated
Concurrent Request including XML Publisher generated output will be
stored in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_CONC_REQ_OUTPUTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONCURRENT_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
CONCURRENT_REQUEST_ID NUMBER
Yes Concurrent Request_ID
OUTPUT_ID NUMBER
Yes Sequence number generated for this output file
FILE_TYPE VARCHAR2 (30) Yes Represents the output file type
FILE_NAME VARCHAR2 (255) Yes File name with full path
FILE_NODE_NAME VARCHAR2 (255) Yes File Node Name
FILE_SIZE NUMBER

File Size
ACTION_TYPE NUMBER

PP_ACTION type will store 6 for XML Publisher output.
FILE_CREATION_DATE DATE
Yes File Creation date
Query Text

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


SELECT CONCURRENT_REQUEST_ID
,      OUTPUT_ID
,      FILE_TYPE
,      FILE_NAME
,      FILE_NODE_NAME
,      FILE_SIZE
,      ACTION_TYPE
,      FILE_CREATION_DATE
FROM APPLSYS.FND_CONC_REQ_OUTPUTS;

Dependencies

[top of page]

APPLSYS.FND_CONC_REQ_OUTPUTS does not reference any database object

APPLSYS.FND_CONC_REQ_OUTPUTS is referenced by following:

SchemaAPPS
SynonymFND_CONC_REQ_OUTPUTS