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

TABLE: OZF.OZF_CLAIM_LINES_ALL

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


OZF_CLAIM_LINES_ALL stores Claim lines for every Claim header


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_CLAIM_LINES_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_LINE_ID
OZF_CLAIM_LINES_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLAIM_ID
OZF_CLAIM_LINES_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY_ID
Columns
Name Datatype Length Mandatory Comments
CLAIM_LINE_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_ID NUMBER
Yes Claim 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)
Currency Exchange Rate Type
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 (30)
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
BUY_GROUP_CUST_ACCOUNT_ID NUMBER

Account identifier of buying group customer whose earnings are associated
SELECT_CUST_CHILDREN_FLAG VARCHAR2 (1)
Select Customer Children Accounts
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 NUMBER

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 of buying group customer whose earnings are associated
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
BATCH_LINE_ID NUMBER

Ship & Debit Batch Line ID
Query Text

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


SELECT CLAIM_LINE_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_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
,      BUY_GROUP_CUST_ACCOUNT_ID
,      SELECT_CUST_CHILDREN_FLAG
,      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
,      BATCH_LINE_ID
FROM OZF.OZF_CLAIM_LINES_ALL;

Dependencies

[top of page]

OZF.OZF_CLAIM_LINES_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_ALL is referenced by following:

SchemaAPPS
SynonymOZF_CLAIM_LINES
SynonymOZF_CLAIM_LINES_ALL
Materialized ViewOZF_CUST_FUND_SUMMARY_MV