[Home] [Help] [Dependency Information]
Object Name: | OKL_SO_PLAN_DETAILS_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_SO_PLAN_DETAILS_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 |
---|---|---|---|---|
PAYMENT_PLAN_ID | NUMBER | Payment Plan ID | ||
PLAN_NAME | VARCHAR2 | (150) | Plan Name (Derived) | |
CHR_ID | NUMBER | Contract ID | ||
SOPYSC_RG_ID | NUMBER | Yes | SOPYSC Rule Group ID | |
SOPMSC_RULE_ID | NUMBER | Yes | SOPMSC Rule ID | |
SOPSST_RULE_ID | NUMBER | Yes | SOPSST Rule ID | |
SORVGT_RULE_ID | NUMBER | Yes | SORVGT Rule ID | |
PLAN_STATUS_CODE | VARCHAR2 | (450) | Plan Status Code | |
PLAN_STATUS | VARCHAR2 | (80) | Yes | Meaning of Plan Status code |
PRICING_ENGINE_CODE | VARCHAR2 | (450) | for future use | |
PRICING_METHOD_CODE | VARCHAR2 | (450) | Pricing Method code | |
RATE_CARD_ID | NUMBER | Rate Card ID | ||
RATE_CARD | VARCHAR2 | (150) | Rate Card name | |
RATE | VARCHAR2 | (450) | Interest Rate | |
PAYMENT_STRUCTURE_CODE | VARCHAR2 | (450) | Payment Structure code | |
BOOK_CLASS_CODE | VARCHAR2 | (450) | Book Classification code | |
TAX_OWNER_CODE | VARCHAR2 | (450) | Tax Owner code | |
GUARANTEE_TYPE_CODE | VARCHAR2 | (450) | Guarantee Type code | |
GUARANTEE_AMOUNT | VARCHAR2 | (450) | Guarantee Amount | |
CALCULATE_RVI_YN | VARCHAR2 | (450) | Indicator to auto calculate Residual Value Insurance (currently not used in pricing) | |
RVI_RATE | VARCHAR2 | (450) | Residual Value Insurance rate | |
FREQUENCY_CODE | VARCHAR2 | (30) | ||
ARREARS_YN | VARCHAR2 | (3) | ||
ESTIMATED_TAX_PERCENTAGE | VARCHAR2 | (450) | ||
SAVE_POINT | VARCHAR2 | (450) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_PLAN_ID
, PLAN_NAME
, CHR_ID
, SOPYSC_RG_ID
, SOPMSC_RULE_ID
, SOPSST_RULE_ID
, SORVGT_RULE_ID
, PLAN_STATUS_CODE
, PLAN_STATUS
, PRICING_ENGINE_CODE
, PRICING_METHOD_CODE
, RATE_CARD_ID
, RATE_CARD
, RATE
, PAYMENT_STRUCTURE_CODE
, BOOK_CLASS_CODE
, TAX_OWNER_CODE
, GUARANTEE_TYPE_CODE
, GUARANTEE_AMOUNT
, CALCULATE_RVI_YN
, RVI_RATE
, FREQUENCY_CODE
, ARREARS_YN
, ESTIMATED_TAX_PERCENTAGE
, SAVE_POINT
FROM APPS.OKL_SO_PLAN_DETAILS_UV;
|
|
|