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

TABLE: OZF.OZF_CLAIMS_ALL

Object Details
Object Name: OZF_CLAIMS_ALL
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_CLAIMS_ALL
Subobject Name:
Status: VALID


OZF_CLAIMS_ALL storesall the Claims made in the system


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_CLAIMS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_ID
OZF_CLAIMS_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_NUMBER
OZF_CLAIMS_ALL_F1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("CLAIM_NUMBER")
OZF_CLAIMS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
OZF_CLAIMS_ALL_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDUE_DATE
OZF_CLAIMS_ALL_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROOT_CLAIM_ID
OZF_CLAIMS_ALL_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_CODE
OZF_CLAIMS_ALL_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_TEMPLATE_GROUP_ID
OZF_CLAIMS_ALL_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALES_REP_ID
OZF_CLAIMS_ALL_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTACT_ID
OZF_CLAIMS_ALL_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBROKER_ID
OZF_CLAIMS_ALL_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_REF_NORMALIZED
OZF_CLAIMS_ALL_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_REASON
OZF_CLAIMS_ALL_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_CLAIM_ID
OZF_CLAIMS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_TYPE_ID
OZF_CLAIMS_ALL_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_OBJECT_CLASS
OZF_CLAIMS_ALL_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_OBJECT_ID
OZF_CLAIMS_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREASON_CODE_ID
OZF_CLAIMS_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
OZF_CLAIMS_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNED_TO
OZF_CLAIMS_ALL_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPLIT_FROM_CLAIM_ID
OZF_CLAIMS_ALL_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDUPLICATE_CLAIM_ID
OZF_CLAIMS_ALL_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNER_ID
OZF_CLAIMS_ALL_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_DATE
Columns
Name Datatype Length Mandatory Comments
CLAIM_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_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
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
Yes 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 id 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
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 VARCHAR2 (30)
History event captured for 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
DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column
DEDUCTION_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
DEDUCTION_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
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 through subsequent application
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
CLOSE_STATUS_ID NUMBER

Custom Close Status Identifier
OPEN_STATUS_ID NUMBER

Custom Open Status Identifier
LEGAL_ENTITY_ID NUMBER

Legal Entity Identifier
Query Text

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


SELECT CLAIM_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_NUMBER
,      CLAIM_TYPE_ID
,      CLAIM_DATE
,      DUE_DATE
,      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
,      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
,      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
,      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
,      CLOSE_STATUS_ID
,      OPEN_STATUS_ID
,      LEGAL_ENTITY_ID
FROM OZF.OZF_CLAIMS_ALL;

Dependencies

[top of page]

OZF.OZF_CLAIMS_ALL does not reference any database object

OZF.OZF_CLAIMS_ALL is referenced by following:

SchemaAPPS
SynonymOZF_CLAIMS
SynonymOZF_CLAIMS_ALL
Materialized ViewOZF_CUST_FUND_SUMMARY_MV