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

TABLE: OZF.OZF_XLA_CLAIM_HEADERS

Object Details
Object Name: OZF_XLA_CLAIM_HEADERS
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_XLA_CLAIM_HEADERS
Subobject Name:
Status: VALID


This table stores the SLA Claim Extract Header Data


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_XLA_CLAIM_HEADERS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRELATED_EVENT_ID
ColumnCLAIM_ID
OZF_XLA_CLAIM_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_TYPE_CODE
ColumnCLAIM_ID
OZF_XLA_CLAIM_HEADERS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnXLA_CLAIM_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
XLA_CLAIM_HEADER_ID NUMBER

Unique identifier
EVENT_TYPE_CODE VARCHAR2 (30)
Event Type Code
ENTITY_CODE VARCHAR2 (30)
For Claim it will be always CLAIM_SETTLEMENT
EVENT_ID NUMBER

Event Identifier
CLAIM_ID NUMBER

Claim Identifier
ORG_ID NUMBER

Organization Identifier
CREATION_DATE DATE

Standard WHO Column
CREATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
REVERSAL_FLAG VARCHAR2 (1)
Reversal Flag
RELATED_EVENT_ID NUMBER

Related Event ID
Query Text

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


SELECT XLA_CLAIM_HEADER_ID
,      EVENT_TYPE_CODE
,      ENTITY_CODE
,      EVENT_ID
,      CLAIM_ID
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REVERSAL_FLAG
,      RELATED_EVENT_ID
FROM OZF.OZF_XLA_CLAIM_HEADERS;

Dependencies

[top of page]

OZF.OZF_XLA_CLAIM_HEADERS does not reference any database object

OZF.OZF_XLA_CLAIM_HEADERS is referenced by following:

SchemaOZF
ViewOZF_XLA_CLAIM_HEADERS#