DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.XTR_PAYMENT_SCHEDULE_V

Object Details
Object Name: XTR_PAYMENT_SCHEDULE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_PAYMENT_SCHEDULE_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.XTR_PAYMENT_SCHEDULE_V references the following:

SchemaAPPS
SynonymXTR_PAYMENT_SCHEDULE
APPS.XTR_PAYMENT_SCHEDULE_V is referenced by following:

SchemaAPPS
Package BodyXTR_AUTO_RECONCILIATION - show dependent code
Package BodyXTR_CALCULATION_P - show dependent code
Package BodyXTR_CALC_P - show dependent code
Package BodyXTR_RATE_CHANGE - show dependent code