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: TableOZF.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_CLAIMS_HISTORY_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_HISTORY_ID
OZF_CLAIMS_HISTORY_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_ID
OZF_CLAIMS_HISTORY_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
OZF_CLAIMS_HISTORY_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_OBJECT_ID
OZF_CLAIMS_HISTORY_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECEIPT_ID
OZF_CLAIMS_HISTORY_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROOT_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.
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
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
OFFER_ID NUMBER

Offer ID
PRE_AUTH_DEDUCTION_NUMBER VARCHAR2 (30)
Pre Auth Deduction Number
PRE_AUTH_DEDUCTION_NORMALIZED VARCHAR2 (30)
Pre Auth Deduction Normalized
CUSTOMER_REF_NORMALIZED#2 VARCHAR2 (100)
Normalized Customer Reference Number. Used by Oracle application to perform similar text search on customer reference number.
CUSTOMER_REF_NUMBER#2 VARCHAR2 (100)
Customer Reference Number
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
,      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
,      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
,      OFFER_ID
,      PRE_AUTH_DEDUCTION_NUMBER
,      PRE_AUTH_DEDUCTION_NORMALIZED
,      CUSTOMER_REF_NORMALIZED#2
,      CUSTOMER_REF_NUMBER#2
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:

SchemaOZF
ViewOZF_CLAIMS_HISTORY_ALL#