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]

TABLE: XTR.XTR_PARCEL_SPLITS

Object Details

Object Name:	XTR_PARCEL_SPLITS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_PARCEL_SPLITS
Subobject Name:
Status:	VALID

XTR_PARCEL_SPLITS contains the parcel split detail information for discounted securities deals. Each row corresponds to one parcel split for a discounted securities deal. Each deal can have many parcel splits. PARCEL_SIZE indicates the number of securities each parcel contains. Each parcel is linked to the deal for which the parcel is created by the DEAL_NO column.
This table corresponds to the Parcel Split Details window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_PARCEL_SPLITS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEAL_NO

Columns

Name	Datatype	Length	Mandatory	Comments
AVAILABLE_FOR_RESALE	VARCHAR2	(1)		Flag to indicate if the discounted security deal is available for resale (Y), or not (N)
CONSIDERATION	NUMBER		Yes	Consideration amount
DEAL_NO	NUMBER		Yes	Unique number assigned to each deal
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
FACE_VALUE_AMOUNT	NUMBER		Yes	Amount that the issuer agrees to pay at the maturity date
INTEREST	NUMBER		Yes	Interest amount
ISSUE_BANK	VARCHAR2	(7)		Bank that issues the security
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.
PARCEL_REMAINING	NUMBER			Number of parcel remained that can be resold
PARCEL_SIZE	NUMBER		Yes	Number of securities you bought, sold or issued
PARCEL_SPLIT_NO	NUMBER		Yes	Identifier for the security that you bought, sold or issued in a parcel split for discounted securities deals
REFERENCE_NUMBER	NUMBER			Unique reference number assigned to each security resale
RESERVE_PARCEL	VARCHAR2	(3)		Not currently used
SELECT_FV_AMOUNT	NUMBER			Not currently used
SELECT_NUMBER	NUMBER			Number of securities that you want to sell (Treasury internal use only)
SERIAL_NUMBER	NUMBER			Serial number used for issuing discounted securities
SERIAL_NUMBER_IN	NUMBER			Not currently used
STATUS_CODE	VARCHAR2	(10)	Yes	Code for the execution status of deals and transactions
ORIGINAL_AMOUNT	NUMBER			Not currently used

Query Text

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


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

Dependencies

[top of page]

XTR.XTR_PARCEL_SPLITS does not reference any database object

XTR.XTR_PARCEL_SPLITS is referenced by following:

XTR: XTR_PARCEL_SPLITS#