[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;
|
|
|