[Home] [Help] [Dependency Information]
Object Name: | OKL_CURE_REQUEST_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_CURE_REQUEST_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 |
---|---|---|---|---|
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | ||
PROGRAM_AGREEMENT | VARCHAR2 | (120) | Program agreement | |
CURE_AMOUNT | NUMBER | |||
REPURCHASE_AMOUNT | NUMBER | |||
EFFECTIVE_DATE | DATE | Effective date | ||
CURES_IN_POSSESSION | NUMBER | |||
CURE_AMOUNT_RECEIVED | NUMBER | cure amount received | ||
NEGOTIATED_AMOUNT | NUMBER | negotiated amount | ||
RECEIVED_AMOUNT | NUMBER | received amount | ||
CURE_AMOUNT_ID | NUMBER | |||
CURE_REPORT_ID | NUMBER | |||
VENDOR_ID | NUMBER | vendor ID | ||
VENDOR_SITE_ID | NUMBER | vendor Site ID | ||
VENDOR_CONTACT_ID | NUMBER | vendorcontact ID | ||
APPROVAL_STATUS | VARCHAR2 | (50) | approval status | |
REQUEST_NUMBER | VARCHAR2 | (150) | Report number | |
CURRENCY_CODE | VARCHAR2 | (15) | Oracle Payables invoice number from TAP table | |
CRT_ID | NUMBER | Cure report associated with the cure amount | ||
SELECTED_ON_REQUEST | VARCHAR2 | (1) | for UI purpose | |
REQUEST_ALL_YN | VARCHAR2 | (0) | for UI purpose | |
REQUEST_STATUS | VARCHAR2 | (11) | request status | |
CHR_ID | NUMBER | |||
REPURCHASE_QUOTE_NUMBER | NUMBER | REPURCHASE_QUOTE_NUMBER | ||
QTE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_NUMBER
, CUSTOMER_NAME
, PROGRAM_AGREEMENT
, CURE_AMOUNT
, REPURCHASE_AMOUNT
, EFFECTIVE_DATE
, CURES_IN_POSSESSION
, CURE_AMOUNT_RECEIVED
, NEGOTIATED_AMOUNT
, RECEIVED_AMOUNT
, CURE_AMOUNT_ID
, CURE_REPORT_ID
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, APPROVAL_STATUS
, REQUEST_NUMBER
, CURRENCY_CODE
, CRT_ID
, SELECTED_ON_REQUEST
, REQUEST_ALL_YN
, REQUEST_STATUS
, CHR_ID
, REPURCHASE_QUOTE_NUMBER
, QTE_ID
FROM APPS.OKL_CURE_REQUEST_UV;
APPS.OKL_CURE_REQUEST_UV is not referenced by any database object
|
|
|