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

TABLE: DPP.DPP_XLA_HEADERS

Object Details
Object Name: DPP_XLA_HEADERS
Object Type: TABLE
Owner: DPP
FND Design Data: TableDPP.DPP_XLA_HEADERS
Subobject Name:
Status: VALID


This table will be used to store transaction extract header information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DPP_XLA_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_HEADER_ID
ColumnPP_TRANSACTION_TYPE
ColumnBASE_TRANSACTION_HEADER_ID
DPP_XLA_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESSED_FLAG
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_HEADER_ID NUMBER
Yes This will store the Price Protection Transaction Header ID
PP_TRANSACTION_TYPE VARCHAR2 (30) Yes This will store the Price Protection transaction type
BASE_TRANSACTION_HEADER_ID NUMBER
Yes This will store the trade management claim header ID (for claim settlement) or the Price Protection execution process ID (for cost update)
PROCESSED_FLAG VARCHAR2 (1) Yes Processed Flag. Default value will be N.
ERROR_DESCRIPTION VARCHAR2 (500)
Description of the Error encountered (if any) while processing the Price Protection transaction header
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER
Yes Standard WHO Column
Query Text

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


SELECT TRANSACTION_HEADER_ID
,      PP_TRANSACTION_TYPE
,      BASE_TRANSACTION_HEADER_ID
,      PROCESSED_FLAG
,      ERROR_DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM DPP.DPP_XLA_HEADERS;

Dependencies

[top of page]

DPP.DPP_XLA_HEADERS does not reference any database object

DPP.DPP_XLA_HEADERS is referenced by following:

SchemaDPP
ViewDPP_XLA_HEADERS#