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_BILL_BOND_ISSUES

Object Details

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

XTR_BILL_BOND_ISSUES contains bill and bond issue serial numbers and information about the deals to which they are assigned. Each row in this table corresponds to bill or bond serial number. When you create a deal to issue a bill or bond, you assign the bill or bond an issue number from this table. Note you must create a separate deal for each bill or bond that you issue. You cannot create a single deal with multiple parcels as you can when you buy or sell bills or bonds. The deal information is automatically entered into the row of this table that corresponds to the assigned serial number.
This table corresponds to the Bill/Bond Issue Numbers window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_BILL_BOND_ISSUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SERIAL_NUMBER NI_OR_BOND BANK_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
AMOUNT	NUMBER			Transaction amount
BANK_CODE	VARCHAR2	(7)		Bank code for the issue number
CURRENCY	VARCHAR2	(15)		Currency code
DEAL_NUMBER	NUMBER			Unique number assigned to each deal
DUE_DATE	DATE			Not currently used
ISSUE_DATE	DATE			Not currently used
NI_OR_BOND	VARCHAR2	(4)	Yes	Code to indicate if the issue number is for a bill (NI) or bond (BOND)
PARCEL_SPLIT_NO	NUMBER			Not currently used
SERIAL_NUMBER	NUMBER		Yes	Serial number used for bond or bill issues
STATUS	VARCHAR2	(10)		Code for the execution status of the issue
TRANSACTION_NUMBER	NUMBER			Transaction Number
BANK_ID	NUMBER	(15)		Bank ID for the issue number

Query Text

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


SELECT AMOUNT
,      BANK_CODE
,      CURRENCY
,      DEAL_NUMBER
,      DUE_DATE
,      ISSUE_DATE
,      NI_OR_BOND
,      PARCEL_SPLIT_NO
,      SERIAL_NUMBER
,      STATUS
,      TRANSACTION_NUMBER
,      BANK_ID
FROM XTR.XTR_BILL_BOND_ISSUES;

Dependencies

[top of page]

XTR.XTR_BILL_BOND_ISSUES does not reference any database object

XTR.XTR_BILL_BOND_ISSUES is referenced by following:

XTR: XTR_BILL_BOND_ISSUES#