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_ACCRUALS

Object Details

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

This table stores SLA Accrual extract information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_XLA_ACCRUALS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	UTILIZATION_ID
OZF_XLA_ACCRUALS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_TYPE_CODE UTILIZATION_ID
OZF_XLA_ACCRUALS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XLA_ACCRUAL_ID

Columns

Name	Datatype	Length	Comments
XLA_ACCRUAL_ID	NUMBER		Xla Accrual Identifier
EVENT_TYPE_CODE	VARCHAR2	(30)	Event Type Code
ENTITY_CODE	VARCHAR2	(30)	Entity Code
EVENT_ID	NUMBER		Event Identifier
UTILIZATION_ID	NUMBER		Utilization Id
ADJUSTMENT_CR_ACCT_CCID	NUMBER		Adjustment Credit Account passed from public API
ADJUSTMENT_DR_ACCT_CCID	NUMBER		Adjustment Debit Account passed from public API
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
ACTG_ACCRUAL_ACCT_CCID	NUMBER		Account Generator Accrual Account
ACTG_EXPENSE_ACCT_CCID	NUMBER		Account Generator Expense Account

Query Text

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


SELECT XLA_ACCRUAL_ID
,      EVENT_TYPE_CODE
,      ENTITY_CODE
,      EVENT_ID
,      UTILIZATION_ID
,      ADJUSTMENT_CR_ACCT_CCID
,      ADJUSTMENT_DR_ACCT_CCID
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ACTG_ACCRUAL_ACCT_CCID
,      ACTG_EXPENSE_ACCT_CCID
FROM OZF.OZF_XLA_ACCRUALS;

Dependencies

[top of page]

OZF.OZF_XLA_ACCRUALS does not reference any database object

OZF.OZF_XLA_ACCRUALS is referenced by following:

OZF: OZF_XLA_ACCRUALS#