[Home] [Help] [Dependency Information]
Object Name: | OKL_CURE_INVOICE_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_CURE_INVOICE_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURE_AMOUNT_ID | NUMBER | Yes | Primary key column | |
CURE_REPORT_ID | NUMBER | Yes | Primary key column | |
REQUEST_NUMBER | VARCHAR2 | (150) | Yes | |
REQUEST_DATE | DATE | Yes | Report date | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code as defined in FND_CURRENCIES. |
VENDOR_ID | NUMBER | Yes | Foreign key to PO_VENDORS | |
VENDOR_SITE_ID | NUMBER | Yes | Foreign key to PO_VENDOR_SITES_ALL | |
VENDOR_CONTACT_ID | NUMBER | Yes | Foreign key to PO_VENDOR_CONTACTS | |
APPROVAL_STATUS | VARCHAR2 | (50) | Approval status | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract number |
PROGRAM_AGREEMENT | VARCHAR2 | (120) | Yes | PROGRAM AGREEMENT |
CURE_AMOUNT | NUMBER | CURE AMOUNT | ||
CURE_AMOUNT_RECEIVED | NUMBER | CURE AMOUNT RECEIVED | ||
NEGOTIATED_AMOUNT | NUMBER | NEGOTIATED AMOUNT | ||
INVOICE_DATE | DATE | Invoice date | ||
SHORT_FUND_ALLOWED | VARCHAR2 | (3) | short fund allowed | |
TOTAL_NEGOTIATED_AMOUNT | NUMBER | TOTAL NEGOTIATED AMOUNT | ||
APPROVAL_STATUS_MEANING | VARCHAR2 | (80) | Yes | Meaning |
REPORT_TYPE_MEANING | VARCHAR2 | (80) | Yes | |
REPORT_TYPE | VARCHAR2 | (20) | report type | |
REPURCHASE_AMOUNT | NUMBER | repurchase amount | ||
PROCESS | VARCHAR2 | (50) | ||
REPURCHASE_QUOTE_NUMBER | NUMBER | repurchase quote number | ||
QTE_ID | NUMBER | Quote Identifier | ||
CHR_ID | NUMBER | Yes | contract Id |
Cut, paste (and edit) the following text to query this object:
SELECT CURE_AMOUNT_ID
, CURE_REPORT_ID
, REQUEST_NUMBER
, REQUEST_DATE
, CURRENCY_CODE
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, APPROVAL_STATUS
, CONTRACT_NUMBER
, PROGRAM_AGREEMENT
, CURE_AMOUNT
, CURE_AMOUNT_RECEIVED
, NEGOTIATED_AMOUNT
, INVOICE_DATE
, SHORT_FUND_ALLOWED
, TOTAL_NEGOTIATED_AMOUNT
, APPROVAL_STATUS_MEANING
, REPORT_TYPE_MEANING
, REPORT_TYPE
, REPURCHASE_AMOUNT
, PROCESS
, REPURCHASE_QUOTE_NUMBER
, QTE_ID
, CHR_ID
FROM APPS.OKL_CURE_INVOICE_UV;
APPS.OKL_CURE_INVOICE_UV is not referenced by any database object
|
|
|