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_CLAIM_LINES_UTIL_ALL

Object Details

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

OZF_CLAIM_LINE_EARNINGS_ALL stores the earnings that have been associated to claim lines for settling the claim. Earnings associated to lines can be partial/full.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_CLAIM_LINES_UTIL_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLAIM_LINE_UTIL_ID
OZF_CLAIM_LINES_UTIL_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLAIM_LINE_ID
OZF_CLAIM_LINES_UTIL_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UTILIZATION_ID
OZF_CLAIM_LINES_UTIL_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_PRODUCT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CLAIM_LINE_UTIL_ID	NUMBER		Yes	Unique Identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number used for database locking control when using HTML as a user interface
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
CLAIM_LINE_ID	NUMBER		Yes	Claim Line Identifier
UTILIZATION_ID	NUMBER		Yes	Utilization Identifier
AMOUNT	NUMBER			Amount associated to a line from utilization
CURRENCY_CODE	VARCHAR2	(15)		Currency code of utilization
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type
EXCHANGE_RATE_DATE	DATE			Exchange rate date
EXCHANGE_RATE	NUMBER			Exchange rate
ACCTD_AMOUNT	NUMBER			Amount associated to a line in functional currency
ORG_ID	NUMBER		Yes	Organization Identifier
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
SCAN_UNIT	NUMBER			Actual scan units associated to the claim line
ACTIVITY_PRODUCT_ID	NUMBER			Offer product profile Id
UOM_CODE	VARCHAR2	(3)		Unit of Measuer of scan data.
QUANTITY	NUMBER			Quantity of the scan data.
UTIL_CURR_AMOUNT	NUMBER			Amount associated to a line in utilization currency
PLAN_CURR_AMOUNT	NUMBER			Amount associated to a line in offer currency
UTILIZED_ACCTD_AMOUNT	NUMBER			Actual amount utilized by the line in functional currency
FXGL_ACCTD_AMOUNT	NUMBER			Foreign Exchange Gain Loss in funtional currency
UNIV_CURR_AMOUNT	NUMBER			Amount associated to a line in universal currency

Query Text

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


SELECT CLAIM_LINE_UTIL_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CLAIM_LINE_ID
,      UTILIZATION_ID
,      AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      ACCTD_AMOUNT
,      ORG_ID
,      SECURITY_GROUP_ID
,      SCAN_UNIT
,      ACTIVITY_PRODUCT_ID
,      UOM_CODE
,      QUANTITY
,      UTIL_CURR_AMOUNT
,      PLAN_CURR_AMOUNT
,      UTILIZED_ACCTD_AMOUNT
,      FXGL_ACCTD_AMOUNT
,      UNIV_CURR_AMOUNT
FROM OZF.OZF_CLAIM_LINES_UTIL_ALL;

Dependencies

[top of page]

OZF.OZF_CLAIM_LINES_UTIL_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_UTIL_ALL is referenced by following:

APPS: OZF_CLAIM_LINES_UTIL; OZF_CLAIM_LINES_UTIL_ALL; OZF_CUST_FUND_SUMMARY_MV