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_CLAIMS_HISTORY_ALL

Object Details

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

OZF_CLAIMS_HISTORY_ALL stores the history information for all the claims that are entered in the system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_CLAIMS_HISTORY_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLAIM_HISTORY_ID
OZF_CLAIMS_HISTORY_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLAIM_ID
OZF_CLAIMS_HISTORY_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID
OZF_CLAIMS_HISTORY_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_OBJECT_ID
OZF_CLAIMS_HISTORY_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_ID
OZF_CLAIMS_HISTORY_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROOT_CLAIM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CLAIM_HISTORY_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
REQUEST_ID	NUMBER			Standard WHO Column
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column
PROGRAM_ID	NUMBER			Standard WHO Column
CREATED_FROM	VARCHAR2	(30)		Standard WHO Column
BATCH_ID	NUMBER			Batch Identifier
CLAIM_ID	NUMBER		Yes	Claim Identifier.
CLAIM_NUMBER	VARCHAR2	(30)		Claim Number
CLAIM_TYPE_ID	NUMBER		Yes	Claim Type Identifier.
CLAIM_DATE	DATE		Yes	Claim Date
DUE_DATE	DATE			Claim due date
HISTORY_EVENT	VARCHAR2	(30)		History event captured for claim
SPLIT_FROM_CLAIM_ID	NUMBER			Reference to Claim after split
AMOUNT	NUMBER			Original Claim Amount
ACCTD_AMOUNT	NUMBER			Amount in functional currency
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Type Currency Exchange Rate
EXCHANGE_RATE_DATE	DATE			Currency Exchange Date
EXCHANGE_RATE	NUMBER			Currency Exchange Rate
SET_OF_BOOKS_ID	NUMBER			Set of Books Identifier
ORIGINAL_CLAIM_DATE	DATE			Date original claim entered
SOURCE_OBJECT_ID	NUMBER			Source Object identefier
SOURCE_OBJECT_CLASS	VARCHAR2	(15)		Source Object Class
SOURCE_OBJECT_TYPE_ID	NUMBER			Source Object Type identefier
SOURCE_OBJECT_NUMBER	VARCHAR2	(30)		Source Object Number
CUST_ACCOUNT_ID	NUMBER		Yes	Billing Account identifier of the Claiming Customer
CUST_BILLTO_ACCT_SITE_ID	NUMBER			Customer Bill To account site identifier
LOCATION_ID	NUMBER			Location Identifier.
REASON_TYPE	VARCHAR2	(30)		Reason Type
REASON_CODE_ID	NUMBER			Reason code Identifier
STATUS_CODE	VARCHAR2	(30)		Status of Claim
SALES_REP_ID	NUMBER			Sales repersentative identifier
COLLECTOR_ID	NUMBER			Collector Identifier
CONTACT_ID	NUMBER			Contact Identifier
BROKER_ID	NUMBER			Broker identefier
TERRITORY_ID	NUMBER			Territory identifier
CUSTOMER_REF_DATE	DATE			Date when customer is being referred.
CUSTOMER_REF_NUMBER	VARCHAR2	(30)		Customer Reference Number
ASSIGNED_TO	NUMBER			assignee identifier
RECEIPT_ID	NUMBER			Receipt identefier
RECEIPT_NUMBER	VARCHAR2	(30)		Receipt Number
DOC_SEQUENCE_ID	NUMBER			Document sequence identifier.
DOC_SEQUENCE_VALUE	NUMBER			Document sequence value
PAYMENT_METHOD	VARCHAR2	(30)		Payment method
VOUCHER_ID	NUMBER			Voucher identifier
VOUCHER_NUMBER	VARCHAR2	(30)		Voucher number
PAYMENT_REFERENCE_ID	NUMBER			Payment reference identifier
PAYMENT_REFERENCE_NUMBER	VARCHAR2	(30)		Payment reference number
PAYMENT_REFERENCE_DATE	DATE			Payment reference date
PAYMENT_STATUS	VARCHAR2	(30)		Payment status
APPROVED_FLAG	VARCHAR2	(1)		Settlement approved flag
APPROVED_DATE	DATE			Date when claim settled
APPROVED_BY	NUMBER			Settlement approved by
SETTLED_DATE	DATE			Date when claim settled
SETTLED_BY	NUMBER			Identifier of user settling claim
LETTER_ID	NUMBER			Obsolete
LETTER_DATE	DATE			Obsolete
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
ORG_ID	NUMBER		Yes	Organization Identifier
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
AMOUNT_ADJUSTED	NUMBER			Amount Adjusted
AMOUNT_REMAINING	NUMBER			Amount Remaining
AMOUNT_SETTLED	NUMBER			Amount Settled
USER_STATUS_ID	NUMBER			User status identifeir
CLAIM_CLASS	VARCHAR2	(30)		Class of claim
OWNER_ID	NUMBER			Owner of the Claim
HISTORY_EVENT_DATE	DATE			Date history event captured
HISTORY_EVENT_DESCRIPTION	VARCHAR2	(2000)		Description of the history event
DUPLICATE_CLAIM_ID	NUMBER			Duplicate claim identifier
SPLIT_DATE	DATE			Date Claim got split
ROOT_CLAIM_ID	NUMBER			Claim Identifier in which transaction was started
ACCTD_AMOUNT_REMAINING	NUMBER			Amount remaining in functional currency
TAX_AMOUNT	NUMBER			Tax amount applied for the claim
TAX_CODE	VARCHAR2	(50)		Tax code to be used on tax calculations
TAX_CALCULATION_FLAG	VARCHAR2	(1)		Flag to indicate whether tax needs to be calculated
CUST_SHIPTO_ACCT_SITE_ID	NUMBER			Ship to customer account site identifier
PAY_RELATED_ACCOUNT_FLAG	VARCHAR2	(1)		Flag to indicate if related customer gets paid
RELATED_CUST_ACCOUNT_ID	NUMBER			Identifier of the customer related to claim customer
RELATED_SITE_USE_ID	NUMBER			Related customer site use identifier
RELATIONSHIP_TYPE	VARCHAR2	(30)		Type of relation between claim customer and settling customer
VENDOR_ID	NUMBER			Identifier of vendor to which check payment is made
VENDOR_SITE_ID	NUMBER			Identifier of vendor site to which check payment is made
TASK_TEMPLATE_GROUP_ID	NUMBER			Action performed on the claim
GL_DATE	DATE			Date posted to GL
EFFECTIVE_DATE	DATE			Date payment is made effective
CUSTOM_SETUP_ID	NUMBER			Identifier of custom setup used by the claim
TASK_ID	NUMBER			Identifier of task for calender integration
COUNTRY_ID	NUMBER			Country identifier for claim
COMMENTS	VARCHAR2	(2000)		Deduction Comments
TASK_SOURCE_OBJECT_ID	NUMBER			Claim identifier that contains task details
TASK_SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Source of the claim identifier that contains task details
DEDUCTION_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Structure Defining Column
ACCTD_AMOUNT_ADJUSTED	NUMBER			Amount adjusted in functional currency
ACCTD_AMOUNT_SETTLED	NUMBER			Amount settled in functional currency
CUSTOMER_REF_NORMALIZED	VARCHAR2	(30)		Normalized Customer Reference Number. Used by Oracle application to perform similar text search on customer reference number.
ORDER_TYPE_ID	NUMBER			Transaction type id from Order Management.
BATCH_TYPE	VARCHAR2	(30)		Batch Type
GROUP_CLAIM_ID	NUMBER			Group Claim Identifier
ACCTD_TAX_AMOUNT	NUMBER			Tax amount in functional currency
SHIP_TO_CUST_ACCOUNT_ID	NUMBER			Shipping account identifier of the customer
CUSTOMER_REASON	VARCHAR2	(30)		Customer Reason
WO_REC_TRX_ID	NUMBER			Write off receivables activity type identifier
WRITE_OFF_FLAG	VARCHAR2	(1)		Indicates if claim can be written off
WRITE_OFF_THRESHOLD_AMOUNT	NUMBER			Threshold amount for write off
UNDER_WRITE_OFF_THRESHOLD	VARCHAR2	(5)		Indicates if claim falls under write off threshold
AMOUNT_APPLIED	NUMBER			Amount applied from receivables thro
APPLIED_RECEIPT_ID	NUMBER			Cash receipt identifier that has the last application
APPLIED_RECEIPT_NUMBER	VARCHAR2	(30)		Cash receipt number that has the last application
APPR_WF_ITEM_KEY	VARCHAR2	(240)		Itemkey of the workflow invoked for approvals
CSTL_WF_ITEM_KEY	VARCHAR2	(240)		Itemkey of the workflow invoked for claims settlement

Query Text

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


SELECT CLAIM_HISTORY_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      CREATED_FROM
,      BATCH_ID
,      CLAIM_ID
,      CLAIM_NUMBER
,      CLAIM_TYPE_ID
,      CLAIM_DATE
,      DUE_DATE
,      HISTORY_EVENT
,      SPLIT_FROM_CLAIM_ID
,      AMOUNT
,      ACCTD_AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      SET_OF_BOOKS_ID
,      ORIGINAL_CLAIM_DATE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_CLASS
,      SOURCE_OBJECT_TYPE_ID
,      SOURCE_OBJECT_NUMBER
,      CUST_ACCOUNT_ID
,      CUST_BILLTO_ACCT_SITE_ID
,      LOCATION_ID
,      REASON_TYPE
,      REASON_CODE_ID
,      STATUS_CODE
,      SALES_REP_ID
,      COLLECTOR_ID
,      CONTACT_ID
,      BROKER_ID
,      TERRITORY_ID
,      CUSTOMER_REF_DATE
,      CUSTOMER_REF_NUMBER
,      ASSIGNED_TO
,      RECEIPT_ID
,      RECEIPT_NUMBER
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PAYMENT_METHOD
,      VOUCHER_ID
,      VOUCHER_NUMBER
,      PAYMENT_REFERENCE_ID
,      PAYMENT_REFERENCE_NUMBER
,      PAYMENT_REFERENCE_DATE
,      PAYMENT_STATUS
,      APPROVED_FLAG
,      APPROVED_DATE
,      APPROVED_BY
,      SETTLED_DATE
,      SETTLED_BY
,      LETTER_ID
,      LETTER_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
,      AMOUNT_ADJUSTED
,      AMOUNT_REMAINING
,      AMOUNT_SETTLED
,      USER_STATUS_ID
,      CLAIM_CLASS
,      OWNER_ID
,      HISTORY_EVENT_DATE
,      HISTORY_EVENT_DESCRIPTION
,      DUPLICATE_CLAIM_ID
,      SPLIT_DATE
,      ROOT_CLAIM_ID
,      ACCTD_AMOUNT_REMAINING
,      TAX_AMOUNT
,      TAX_CODE
,      TAX_CALCULATION_FLAG
,      CUST_SHIPTO_ACCT_SITE_ID
,      PAY_RELATED_ACCOUNT_FLAG
,      RELATED_CUST_ACCOUNT_ID
,      RELATED_SITE_USE_ID
,      RELATIONSHIP_TYPE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      TASK_TEMPLATE_GROUP_ID
,      GL_DATE
,      EFFECTIVE_DATE
,      CUSTOM_SETUP_ID
,      TASK_ID
,      COUNTRY_ID
,      COMMENTS
,      TASK_SOURCE_OBJECT_ID
,      TASK_SOURCE_OBJECT_TYPE_CODE
,      DEDUCTION_ATTRIBUTE_CATEGORY
,      DEDUCTION_ATTRIBUTE1
,      DEDUCTION_ATTRIBUTE2
,      DEDUCTION_ATTRIBUTE3
,      DEDUCTION_ATTRIBUTE4
,      DEDUCTION_ATTRIBUTE5
,      DEDUCTION_ATTRIBUTE6
,      DEDUCTION_ATTRIBUTE7
,      DEDUCTION_ATTRIBUTE8
,      DEDUCTION_ATTRIBUTE9
,      DEDUCTION_ATTRIBUTE10
,      DEDUCTION_ATTRIBUTE11
,      DEDUCTION_ATTRIBUTE12
,      DEDUCTION_ATTRIBUTE13
,      DEDUCTION_ATTRIBUTE14
,      DEDUCTION_ATTRIBUTE15
,      ACCTD_AMOUNT_ADJUSTED
,      ACCTD_AMOUNT_SETTLED
,      CUSTOMER_REF_NORMALIZED
,      ORDER_TYPE_ID
,      BATCH_TYPE
,      GROUP_CLAIM_ID
,      ACCTD_TAX_AMOUNT
,      SHIP_TO_CUST_ACCOUNT_ID
,      CUSTOMER_REASON
,      WO_REC_TRX_ID
,      WRITE_OFF_FLAG
,      WRITE_OFF_THRESHOLD_AMOUNT
,      UNDER_WRITE_OFF_THRESHOLD
,      AMOUNT_APPLIED
,      APPLIED_RECEIPT_ID
,      APPLIED_RECEIPT_NUMBER
,      APPR_WF_ITEM_KEY
,      CSTL_WF_ITEM_KEY
FROM OZF.OZF_CLAIMS_HISTORY_ALL;

Dependencies

[top of page]

OZF.OZF_CLAIMS_HISTORY_ALL does not reference any database object

OZF.OZF_CLAIMS_HISTORY_ALL is referenced by following:

APPS: OZF_CLAIMS_HISTORY; OZF_CLAIMS_HISTORY_ALL