[Home] [Help] [Dependency Information]
Object Name: | XTR_BILL_BOND_ISSUES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_BILL_BOND_ISSUES_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 |
---|---|---|---|---|
NI_OR_BOND | VARCHAR2 | (4) | Yes | Code to indicate if the issue number is for a bill (NI) or bond (BOND) |
BANK_CODE | VARCHAR2 | (7) | Bank code for the issue number | |
SERIAL_NUMBER | NUMBER | Yes | Serial number used for bond or bill issues | |
ISSUE_DATE | DATE | Not currently used | ||
DEAL_NUMBER | NUMBER | Unique number assigned to each deal | ||
PARCEL_SPLIT_NO | NUMBER | Not currently used | ||
STATUS | VARCHAR2 | (10) | Code for the execution status of the issue | |
DUE_DATE | DATE | Not currently used | ||
CURRENCY | VARCHAR2 | (15) | Currency code | |
AMOUNT | NUMBER | Transaction amount | ||
TRANSACTION_NUMBER | NUMBER | Transaction Number |
Cut, paste (and edit) the following text to query this object:
SELECT NI_OR_BOND
, BANK_CODE
, SERIAL_NUMBER
, ISSUE_DATE
, DEAL_NUMBER
, PARCEL_SPLIT_NO
, STATUS
, DUE_DATE
, CURRENCY
, AMOUNT
, TRANSACTION_NUMBER
FROM APPS.XTR_BILL_BOND_ISSUES_V;
|
|
|