[Home] [Help] [Dependency Information]
Object Name: | XTR_PARCEL_SPLITS# |
---|---|
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AVAILABLE_FOR_RESALE | VARCHAR2 | (1) | ||
CONSIDERATION | NUMBER | Yes | ||
DEAL_NO | NUMBER | Yes | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | |
FACE_VALUE_AMOUNT | NUMBER | Yes | ||
INTEREST | NUMBER | Yes | ||
ISSUE_BANK | VARCHAR2 | (7) | ||
OLD_SELECT_NUMBER | NUMBER | |||
PARCEL_REMAINING | NUMBER | |||
PARCEL_SIZE | NUMBER | Yes | ||
PARCEL_SPLIT_NO | NUMBER | Yes | ||
REFERENCE_NUMBER | NUMBER | |||
RESERVE_PARCEL | VARCHAR2 | (3) | ||
SELECT_FV_AMOUNT | NUMBER | |||
SELECT_NUMBER | NUMBER | |||
SERIAL_NUMBER | NUMBER | |||
SERIAL_NUMBER_IN | NUMBER | |||
STATUS_CODE | VARCHAR2 | (10) | Yes | |
ORIGINAL_AMOUNT | NUMBER |
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#;
|
|
|