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

TABLE: OZF.OZF_CLAIM_LINES_INT_ALL

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


This interface table temporarily stores the claim line data until is the data is processed and successfully imported into Oracle Trade Management
Scope: public
Product: OZF
Lifecycle: active
Display Name: Claim Lines Interface Table
Category: BUSINESS_ENTITY OZF_CLAIM
Category: OPEN_INTERFACE OZF_CLAIM_INTERFACE 1


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_CLAIM_LINES_INT_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_CLAIM_LINE_ID
OZF_CLAIM_LINES_INT_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_CLAIM_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_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
INTERFACE_CLAIM_ID NUMBER
Yes Claim Identifier
LINE_NUMBER NUMBER

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

Set of Books Identifier
VALID_FLAG VARCHAR2 (1)
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)
Flag to indicate if performance was completed
PERFORMANCE_ATTACHED_FLAG VARCHAR2 (1)
Flag to indicate if performance was attached
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)
Item 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 (240)
Flag to indicate if earnings are associated
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
SALE_DATE DATE

Sale Date
PRORATE_EARNINGS_FLAG VARCHAR2 (1)
Prorate Earnings Flag
EARNINGS_END_DATE DATE

End Date for earnings associated to line
BUY_GROUP_PARTY_ID NUMBER

Party Identifier of the Buying Group customer
Query Text

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


SELECT INTERFACE_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
,      INTERFACE_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
,      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
,      SALE_DATE
,      PRORATE_EARNINGS_FLAG
,      EARNINGS_END_DATE
,      BUY_GROUP_PARTY_ID
FROM OZF.OZF_CLAIM_LINES_INT_ALL;

Dependencies

[top of page]

OZF.OZF_CLAIM_LINES_INT_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_INT_ALL is referenced by following:

SchemaAPPS
SynonymOZF_CLAIM_LINES_INT
SynonymOZF_CLAIM_LINES_INT_ALL