eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OZF.OZF_XLA_CLAIM_LINES

Object Details

Object Name:	OZF_XLA_CLAIM_LINES
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_XLA_CLAIM_LINES
Subobject Name:
Status:	VALID

This table stores the SLA Claim Extract Lines Data

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_XLA_CLAIM_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XLA_CLAIM_HEADER_ID

Columns

Name	Datatype	Length	Comments
XLA_CLAIM_LINE_ID	NUMBER		Unique identifier
XLA_CLAIM_HEADER_ID	NUMBER		SLA Claim Extarct Header ID
LINE_NUMBER	NUMBER		Line Number per transaction header
CLAIM_LINE_UTIL_ID	NUMBER		Claim Line Utilization ID
CREATION_DATE	VARCHAR2	(240)	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
ACTG_CLAIM_ACC_ACCT_CCID	NUMBER		Account Generator Claim Accrual Liability Account
ACTG_CLAIM_EXP_ACCT_CCID	NUMBER		Account Generator Claim Expense Account

Query Text

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


SELECT XLA_CLAIM_LINE_ID
,      XLA_CLAIM_HEADER_ID
,      LINE_NUMBER
,      CLAIM_LINE_UTIL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ACTG_CLAIM_ACC_ACCT_CCID
,      ACTG_CLAIM_EXP_ACCT_CCID
FROM OZF.OZF_XLA_CLAIM_LINES;

Dependencies

[top of page]

OZF.OZF_XLA_CLAIM_LINES does not reference any database object

OZF.OZF_XLA_CLAIM_LINES is referenced by following:

OZF: OZF_XLA_CLAIM_LINES#