[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CURE_REFUND_HEADERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_CURE_REFUND_HEADERS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Stores refunds made to vendor for cured contracts. The table will hold refund requests grouped by currency and vendor /contract.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Identifier in the database | |
| CURE_REFUND_HEADER_ID | NUMBER | Yes | Primary key | |
| REFUND_HEADER_NUMBER | VARCHAR2 | (120) | Yes | The natural primary unique identifier of the refund request |
| REFUND_TYPE | VARCHAR2 | (50) | Cure refund request type | |
| REFUND_DUE_DATE | DATE | Request Date | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code as defined in FND_CURRENCIES. |
| TOTAL_REFUND_DUE | NUMBER | total refund due at the time the disbursement was made. This will be the sum (amount paid by vendor ) -sum (disbursment _amount) | ||
| DISBURSEMENT_AMOUNT | NUMBER | disbursed Amount to the vendor | ||
| VENDOR_SITE_ID | NUMBER | Yes | vendor Site ID | |
| REFUND_STATUS | VARCHAR2 | (120) | status from TAP table. This will intially entered as 'CURE_ENTERED' when the batch is submitted ,it will be 'PROCESSED' | |
| PAYMENT_METHOD | VARCHAR2 | (120) | payment method code for the batch | |
| PAYMENT_TERM_ID | NUMBER | payment term ID (ippt_id)from TAP table | ||
| SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
| DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| VENDOR_CURE_DUE | NUMBER | Total outstanding cure at the vendor site level. this is actuially the sum of all cure invoices for which a payment has not been received. | ||
| VENDOR_SITE_CURE_DUE | NUMBER | Total outstanding cure at the vendor site level. this is actuially the sum of all cure invoices for which a payment has not been received. | ||
| CHR_ID | NUMBER | Contract identifier | ||
| PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
| REQUEST_ID | NUMBER | (15) | Concurrent Manager column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | Descriptive flexfield category column | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| NEGOTIATED_AMOUNT | NUMBER | Negotiated Amount | ||
| RECEIVED_AMOUNT | NUMBER | received amount | ||
| OFFSET_AMOUNT | NUMBER | Cure amount generated for contract |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CURE_REFUND_HEADER_ID
, REFUND_HEADER_NUMBER
, REFUND_TYPE
, REFUND_DUE_DATE
, CURRENCY_CODE
, TOTAL_REFUND_DUE
, DISBURSEMENT_AMOUNT
, VENDOR_SITE_ID
, REFUND_STATUS
, PAYMENT_METHOD
, PAYMENT_TERM_ID
, SFWT_FLAG
, DESCRIPTION
, OBJECT_VERSION_NUMBER
, VENDOR_CURE_DUE
, VENDOR_SITE_CURE_DUE
, CHR_ID
, PROGRAM_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, NEGOTIATED_AMOUNT
, RECEIVED_AMOUNT
, OFFSET_AMOUNT
FROM APPS.OKL_CURE_REFUND_HEADERS_V;
APPS
OKL_CURE_REFUND_HEADERS_B
OKL_CURE_REFUND_HEADERS_TL
APPS
OKL_CHD_PVT
- show dependent code
OKL_CHD_PVT
- show dependent code
OKL_CURE_REFUNDS_HDRS_UV
|
|
|
|