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

VIEW: APPS.OZF_CLAIMS_WEBADI_DOWNLOAD_V

Object Details
Object Name: OZF_CLAIMS_WEBADI_DOWNLOAD_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTERFACE_CLAIM_ID NUMBER
Yes Unique identifier
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
CLAIM_NUMBER VARCHAR2 (30)
Claim Number
CLAIM_TYPE_ID NUMBER

Claim Type Identifier.
CLAIM_DATE DATE

Claim Date
DUE_DATE DATE

Claim due date
SPLIT_FROM_CLAIM_ID NUMBER

Reference to Claim after split
HDR_AMOUNT NUMBER

Original Claim Amount
HDR_ACCTD_AMOUNT NUMBER

Amount in functional currency
HDR_CURRENCY_CODE VARCHAR2 (15)
Currency Code
HDR_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Type Currency Exchange Rate
HDR_EXCHANGE_RATE_DATE DATE

Currency Exchange Date
HDR_EXCHANGE_RATE NUMBER

Currency Exchange Rate
HDR_SET_OF_BOOKS_ID NUMBER

Set of Books Identifier
ORIGINAL_CLAIM_DATE DATE

Date original claim entered
HDR_SOURCE_OBJECT_ID NUMBER

Source Object identefier
HDR_SOURCE_OBJECT_CLASS VARCHAR2 (15)
Source Object Class
HDR_SOURCE_OBJECT_TYPE_ID NUMBER

Source Object Type identefier
HDR_SOURCE_OBJECT_NUMBER VARCHAR2 (30)
Source Object Number
CUST_ACCOUNT_ID NUMBER

Billing Account id of the 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 (100)
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
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
CLAIM_ID NUMBER

Claim Identifier.
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)
RELATED_CUST_ACCOUNT_ID NUMBER

Identifier of the customer related to claim customer
RELATED_SITE_USE_ID NUMBER

Related customer site use identifier
VENDOR_ID VARCHAR2 (30)
Identifier of vendor to which check payment is made
CUSTOM_SETUP_ID NUMBER

Identifier of custom setup used by the claim
RELATIONSHIP_TYPE NUMBER

Type of relation between claim customer and settling customer
VENDOR_SITE_ID NUMBER

Identifier of vendor site to which check payment is made
TASK_TEMPLATE_GROUP_ID DATE

Action performed on the claim
GL_DATE DATE

Date posted to GL
EFFECTIVE_DATE NUMBER

Date payment is made effective
LINE_NUMBER NUMBER

claim line number
TASK_ID NUMBER

Identifier of task for calender integration
COUNTRY_ID VARCHAR2 (2000)
Country identifier for claim
COMMENTS NUMBER

Deduction Comments
ACCTD_AMOUNT_ADJUSTED NUMBER

ACCTD_AMOUNT_SETTLED NUMBER

Amount settled in functional currency
ORDER_TYPE_ID NUMBER
Yes Transaction type id from Order Management.
INTERFACE_CLAIM_LINE_ID NUMBER

Unique identifier
SPLIT_FROM_CLAIM_LINE_ID NUMBER

claim id after split
AMOUNT NUMBER

Amount
ACCTD_AMOUNT NUMBER

Calim 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
LIN_PAYMENT_METHOD VARCHAR2 (30)
payment method
LIN_PAYMENT_REFERENCE_ID NUMBER

Payment reference identifier
LIN_PAYMENT_REFERENCE_NUMBER VARCHAR2 (15)
Payment reference number
LIN_PAYMENT_REFERENCE_DATE DATE

Payment reference date
LIN_VOUCHER_ID NUMBER

Voucher identifier
LIN_VOUCHER_NUMBER VARCHAR2 (30)
Voucher number
LIN_PAYMENT_STATUS VARCHAR2 (30)
payment status
LIN_APPROVED_FLAG VARCHAR2 (1)
settlement approved flag
LIN_APPROVED_DATE DATE

date when claim settled
LIN_APPROVED_BY NUMBER

settlement approved by
LIN_SETTLED_DATE DATE

date when claim settled
LIN_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
UTILIZATION_ID NUMBER

Utilization Identifier
CLAIM_CURRENCY_AMOUNT NUMBER

Amount of line in claim currency
LIN_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
LIN_RELATED_CUST_ACCOUNT_ID NUMBER

Account Identifier of related customer whose earnings are associated
LIN_RELATIONSHIP_TYPE VARCHAR2 (30)
Relationship of the account whose earnings are associated
LIN_COMMENTS VARCHAR2 (2000)
Comments
SOURCE_OBJECT_LINE_ID NUMBER

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
Query Text

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


SELECT INTERFACE_CLAIM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CLAIM_NUMBER
,      CLAIM_TYPE_ID
,      CLAIM_DATE
,      DUE_DATE
,      SPLIT_FROM_CLAIM_ID
,      HDR_AMOUNT
,      HDR_ACCTD_AMOUNT
,      HDR_CURRENCY_CODE
,      HDR_EXCHANGE_RATE_TYPE
,      HDR_EXCHANGE_RATE_DATE
,      HDR_EXCHANGE_RATE
,      HDR_SET_OF_BOOKS_ID
,      ORIGINAL_CLAIM_DATE
,      HDR_SOURCE_OBJECT_ID
,      HDR_SOURCE_OBJECT_CLASS
,      HDR_SOURCE_OBJECT_TYPE_ID
,      HDR_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
,      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
,      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
,      VENDOR_ID
,      CUSTOM_SETUP_ID
,      RELATIONSHIP_TYPE
,      VENDOR_SITE_ID
,      TASK_TEMPLATE_GROUP_ID
,      GL_DATE
,      EFFECTIVE_DATE
,      LINE_NUMBER
,      TASK_ID
,      COUNTRY_ID
,      COMMENTS
,      ACCTD_AMOUNT_ADJUSTED
,      ACCTD_AMOUNT_SETTLED
,      ORDER_TYPE_ID
,      INTERFACE_CLAIM_LINE_ID
,      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
,      LIN_PAYMENT_METHOD
,      LIN_PAYMENT_REFERENCE_ID
,      LIN_PAYMENT_REFERENCE_NUMBER
,      LIN_PAYMENT_REFERENCE_DATE
,      LIN_VOUCHER_ID
,      LIN_VOUCHER_NUMBER
,      LIN_PAYMENT_STATUS
,      LIN_APPROVED_FLAG
,      LIN_APPROVED_DATE
,      LIN_APPROVED_BY
,      LIN_SETTLED_DATE
,      LIN_SETTLED_BY
,      PERFORMANCE_COMPLETE_FLAG
,      PERFORMANCE_ATTACHED_FLAG
,      UTILIZATION_ID
,      CLAIM_CURRENCY_AMOUNT
,      LIN_TAX_CODE
,      ITEM_ID
,      ITEM_DESCRIPTION
,      QUANTITY
,      QUANTITY_UOM
,      RATE
,      ACTIVITY_TYPE
,      ACTIVITY_ID
,      EARNINGS_ASSOCIATED_FLAG
,      LIN_RELATED_CUST_ACCOUNT_ID
,      LIN_RELATIONSHIP_TYPE
,      LIN_COMMENTS
,      SOURCE_OBJECT_LINE_ID
,      SELECT_CUST_CHILDREN_FLAG
,      BUY_GROUP_CUST_ACCOUNT_ID
,      CREDIT_TO
FROM APPS.OZF_CLAIMS_WEBADI_DOWNLOAD_V;

Dependencies

[top of page]

APPS.OZF_CLAIMS_WEBADI_DOWNLOAD_V references the following:

SchemaAPPS
SynonymOZF_CLAIMS_INT_ALL
SynonymOZF_CLAIM_LINES_INT_ALL

APPS.OZF_CLAIMS_WEBADI_DOWNLOAD_V is not referenced by any database object