eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.XTR_PARCEL_SPLITS_V

Object Details

Object Name:	XTR_PARCEL_SPLITS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_PARCEL_SPLITS_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_NO	NUMBER		Yes	Unique number assigned to each deal
PARCEL_SPLIT_NO	NUMBER		Yes	Identifier for the security that you bought, sold or issued in a parcel split for discounted securities deals
PARCEL_SIZE	NUMBER		Yes	Number of securities you bought, sold or issued
FACE_VALUE_AMOUNT	NUMBER		Yes	Amount that the issuer agrees to pay at the maturity date
CONSIDERATION	NUMBER		Yes	Consideration amount
INTEREST	NUMBER		Yes	Interest amount
STATUS_CODE	VARCHAR2	(10)	Yes	Code for the execution status of deals and transactions
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
AVAILABLE_FOR_RESALE	VARCHAR2	(1)		Flag to indicate if the discounted security deal is available for resale (Y), or not (N)
PARCEL_REMAINING	NUMBER			Number of parcel remained that can be resold
SELECT_NUMBER	NUMBER			Number of securities that you want to sell (Treasury internal use only)
SELECT_FV_AMOUNT	NUMBER			Not currently used
REFERENCE_NUMBER	NUMBER			Unique reference number assigned to each security resale
RESERVE_PARCEL	VARCHAR2	(3)		Not currently used
OLD_SELECT_NUMBER	NUMBER			Number of securities specified for sale previous to entering the SELECT_NUMBER. The OLD_SELECT_NUMBER is stored and used to help adjust the parcel value based the old number of parcels to sell to the current number of parcels to sell. Removing this column will produce problems with parcel value calculations.
SERIAL_NUMBER	NUMBER			Serial number used for issuing discounted securities
SERIAL_NUMBER_IN	NUMBER			Not currently used
ISSUE_BANK	VARCHAR2	(7)		Bank that issues the security
ORIGINAL_AMOUNT	NUMBER			System calculated interest amount

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEAL_NO
,      PARCEL_SPLIT_NO
,      PARCEL_SIZE
,      FACE_VALUE_AMOUNT
,      CONSIDERATION
,      INTEREST
,      STATUS_CODE
,      DEAL_SUBTYPE
,      AVAILABLE_FOR_RESALE
,      PARCEL_REMAINING
,      SELECT_NUMBER
,      SELECT_FV_AMOUNT
,      REFERENCE_NUMBER
,      RESERVE_PARCEL
,      OLD_SELECT_NUMBER
,      SERIAL_NUMBER
,      SERIAL_NUMBER_IN
,      ISSUE_BANK
,      ORIGINAL_AMOUNT
FROM APPS.XTR_PARCEL_SPLITS_V;

Dependencies

[top of page]

APPS.XTR_PARCEL_SPLITS_V references the following:

APPS: XTR_PARCEL_SPLITS

APPS.XTR_PARCEL_SPLITS_V is not referenced by any database object