[Home] [Help] [Dependency Information]
Object Name: | OZF_CLAIMS_WEBADI_DOWNLOAD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
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 | (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 | |
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 |
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;
APPS.OZF_CLAIMS_WEBADI_DOWNLOAD_V is not referenced by any database object
|
|
|