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

TABLE: OZF.OZF_CLAIM_LINES_HIST_ALL

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


OZF_CLAIM_LINES_HIST_ALL stores the Claim line history for every claim history


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_CLAIM_LINES_HIST_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_LINE_HISTORY_ID
OZF_CLAIM_LINES_HIST_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_HISTORY_ID
OZF_CLAIM_LINES_HIST_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_LINE_ID
Columns
Name Datatype Length Mandatory Comments
CLAIM_LINE_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
CLAIM_HISTORY_ID NUMBER
Yes Claim History Identifier
CLAIM_ID NUMBER
Yes Claim Identifier
CLAIM_LINE_ID NUMBER
Yes Claim Line Identifier
LINE_NUMBER NUMBER
Yes Claim Line Number
SPLIT_FROM_CLAIM_LINE_ID NUMBER

Split from Claim Line Identifier
AMOUNT NUMBER

Amount
ACCTD_AMOUNT NUMBER

Claim group accounted amount
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
VALID_FLAG VARCHAR2 (1) Yes Valid flag
SOURCE_OBJECT_ID NUMBER

Source Object identefier
SOURCE_OBJECT_CLASS VARCHAR2 (15)
Source Object Class
SOURCE_OBJECT_TYPE_ID NUMBER

Source Object Type identefier
PLAN_ID NUMBER

Deal Identifier
OFFER_ID NUMBER

Deal component Identifier
PAYMENT_METHOD VARCHAR2 (30)
Payment method
PAYMENT_REFERENCE_ID NUMBER

Payment reference identifier
PAYMENT_REFERENCE_NUMBER VARCHAR2 (15)
Payment reference number
PAYMENT_REFERENCE_DATE DATE

Payment reference date
VOUCHER_ID NUMBER

Voucher identifier
VOUCHER_NUMBER VARCHAR2 (30)
Voucher number
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

Who settled the claim
PERFORMANCE_COMPLETE_FLAG VARCHAR2 (1)
Performance complete flag
PERFORMANCE_ATTACHED_FLAG VARCHAR2 (1)
Performance attached flag
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
UTILIZATION_ID NUMBER

Utilization Identifier
CLAIM_CURRENCY_AMOUNT NUMBER

Amount of line in claim currency
TAX_CODE VARCHAR2 (50)
Tax Code applied to line
ITEM_ID NUMBER

Product Identifier
ITEM_DESCRIPTION VARCHAR2 (240)
Product Code or Description
QUANTITY NUMBER

Quantity
QUANTITY_UOM VARCHAR2 (30)
Quantity unit of measure
RATE NUMBER

Rate
ACTIVITY_TYPE VARCHAR2 (30)
Marketing Activity Type
ACTIVITY_ID NUMBER

Marketing Activity Identifier
EARNINGS_ASSOCIATED_FLAG VARCHAR2 (1)
Indicates if earnings are associated to the line
RELATED_CUST_ACCOUNT_ID NUMBER

Account Identifier of related customer whose earnings are associated
RELATIONSHIP_TYPE VARCHAR2 (30)
Relationship of the account whose earnings are associated
COMMENTS VARCHAR2 (2000)
Comments
SELECT_CUST_CHILDREN_FLAG VARCHAR2 (1)
Select Cust Children Flag
BUY_GROUP_CUST_ACCOUNT_ID NUMBER

Id of Buy Group Cust Account
CREDIT_TO VARCHAR2 (15)
Credit to
SOURCE_OBJECT_LINE_ID NUMBER

Source Object Line Identification
TAX_AMOUNT NUMBER

Tax amount applied to line
CLAIM_CURR_TAX_AMOUNT NUMBER

Tax amount applied to line in claim currency
ACCTD_TAX_AMOUNT VARCHAR2 (240)
Accounted tax amount applied to line
ITEM_TYPE VARCHAR2 (30)
Product Type
ACTIVITY_LINE_ID NUMBER

Marketing Activity Line Identifier
OFFER_TYPE VARCHAR2 (30)
Offer Type
PRORATE_EARNINGS_FLAG VARCHAR2 (1)
Prorate Earnings Flag
SALE_DATE DATE

Sale Date
EARNINGS_END_DATE DATE

End Date for earnings associated to line
BUY_GROUP_PARTY_ID NUMBER

Party identifier for the Buying Group customer
DPP_CUST_ACCOUNT_ID VARCHAR2 (20)
Price Protection specific. Used to display the customer name in the line level when a claim is created in DPP grouped by currency
ACTIVITY_NAME VARCHAR2 (2000)
Activity Name
Query Text

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


SELECT CLAIM_LINE_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
,      CLAIM_HISTORY_ID
,      CLAIM_ID
,      CLAIM_LINE_ID
,      LINE_NUMBER
,      SPLIT_FROM_CLAIM_LINE_ID
,      AMOUNT
,      ACCTD_AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      SET_OF_BOOKS_ID
,      VALID_FLAG
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_CLASS
,      SOURCE_OBJECT_TYPE_ID
,      PLAN_ID
,      OFFER_ID
,      PAYMENT_METHOD
,      PAYMENT_REFERENCE_ID
,      PAYMENT_REFERENCE_NUMBER
,      PAYMENT_REFERENCE_DATE
,      VOUCHER_ID
,      VOUCHER_NUMBER
,      PAYMENT_STATUS
,      APPROVED_FLAG
,      APPROVED_DATE
,      APPROVED_BY
,      SETTLED_DATE
,      SETTLED_BY
,      PERFORMANCE_COMPLETE_FLAG
,      PERFORMANCE_ATTACHED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
,      UTILIZATION_ID
,      CLAIM_CURRENCY_AMOUNT
,      TAX_CODE
,      ITEM_ID
,      ITEM_DESCRIPTION
,      QUANTITY
,      QUANTITY_UOM
,      RATE
,      ACTIVITY_TYPE
,      ACTIVITY_ID
,      EARNINGS_ASSOCIATED_FLAG
,      RELATED_CUST_ACCOUNT_ID
,      RELATIONSHIP_TYPE
,      COMMENTS
,      SELECT_CUST_CHILDREN_FLAG
,      BUY_GROUP_CUST_ACCOUNT_ID
,      CREDIT_TO
,      SOURCE_OBJECT_LINE_ID
,      TAX_AMOUNT
,      CLAIM_CURR_TAX_AMOUNT
,      ACCTD_TAX_AMOUNT
,      ITEM_TYPE
,      ACTIVITY_LINE_ID
,      OFFER_TYPE
,      PRORATE_EARNINGS_FLAG
,      SALE_DATE
,      EARNINGS_END_DATE
,      BUY_GROUP_PARTY_ID
,      DPP_CUST_ACCOUNT_ID
,      ACTIVITY_NAME
FROM OZF.OZF_CLAIM_LINES_HIST_ALL;

Dependencies

[top of page]

OZF.OZF_CLAIM_LINES_HIST_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_HIST_ALL is referenced by following:

SchemaOZF
ViewOZF_CLAIM_LINES_HIST_ALL#