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

VIEW: APPS.XTR_BILL_BOND_ISSUES_V

Object Details
Object Name: XTR_BILL_BOND_ISSUES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_BILL_BOND_ISSUES_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
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
Query Text

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;

Dependencies

[top of page]

APPS.XTR_BILL_BOND_ISSUES_V references the following:

SchemaAPPS
SynonymXTR_BILL_BOND_ISSUES
APPS.XTR_BILL_BOND_ISSUES_V is referenced by following:

SchemaAPPS
Package BodyXTR_NI_TRANSFERS_PKG - show dependent code