[Home] [Help]
[Dependency Information]
| Object Name: | XTR_PAYMENT_SCHEDULE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XTR.XTR_PAYMENT_SCHEDULE_V
|
| 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 |
|---|---|---|---|---|
| DEAL_TYPE | VARCHAR2 | (7) | Yes | |
| PRODUCT_TYPE | VARCHAR2 | (10) | Yes | |
| DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | |
| PAYMENT_SCHEDULE_CODE | VARCHAR2 | (7) | Yes | |
| DESCRIPTION | VARCHAR2 | (20) | ||
| DEFAULT_YN | VARCHAR2 | (1) | ||
| PAYMENT_FREQUENCY | VARCHAR2 | (12) | ||
| POST_MONTHS_FORWARD | VARCHAR2 | (3) | ||
| CALC_TYPE | VARCHAR2 | (7) | ||
| ADJUST_ON_SETTLE | VARCHAR2 | (1) | ||
| INTEREST_ACTION | VARCHAR2 | (8) | ||
| JAN_YN | VARCHAR2 | (1) | ||
| FEB_YN | VARCHAR2 | (1) | ||
| MAR_YN | VARCHAR2 | (1) | ||
| APR_YN | VARCHAR2 | (1) | ||
| MAY_YN | VARCHAR2 | (1) | ||
| JUN_YN | VARCHAR2 | (1) | ||
| JUL_YN | VARCHAR2 | (1) | ||
| AUG_YN | VARCHAR2 | (1) | ||
| SEP_YN | VARCHAR2 | (1) | ||
| OCT_YN | VARCHAR2 | (1) | ||
| NOV_YN | VARCHAR2 | (1) | ||
| DEC_YN | VARCHAR2 | (1) | ||
| MIN_POSTINGS | NUMBER | |||
| POSTING_FREQ | NUMBER | |||
| NEXT_POSTING_DUE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_TYPE
, PRODUCT_TYPE
, DEAL_SUBTYPE
, PAYMENT_SCHEDULE_CODE
, DESCRIPTION
, DEFAULT_YN
, PAYMENT_FREQUENCY
, POST_MONTHS_FORWARD
, CALC_TYPE
, ADJUST_ON_SETTLE
, INTEREST_ACTION
, JAN_YN
, FEB_YN
, MAR_YN
, APR_YN
, MAY_YN
, JUN_YN
, JUL_YN
, AUG_YN
, SEP_YN
, OCT_YN
, NOV_YN
, DEC_YN
, MIN_POSTINGS
, POSTING_FREQ
, NEXT_POSTING_DUE
FROM APPS.XTR_PAYMENT_SCHEDULE_V;
APPS
XTR_PAYMENT_SCHEDULE
APPS
XTR_AUTO_RECONCILIATION
- show dependent code
XTR_CALCULATION_P
- show dependent code
XTR_CALC_P
- show dependent code
XTR_RATE_CHANGE
- show dependent code
|
|
|
|