[Home] [Help]
View: XTR_P_SPLIT_V
View Text
SELECT A.DEAL_NO
, A.FACE_VALUE_AMOUNT
, A.RESERVE_PARCEL
, A.PARCEL_SIZE
, A.AVAILABLE_FOR_RESALE
, A.PARCEL_REMAINING
, A.STATUS_CODE
, A.DEAL_SUBTYPE
, B.ACCEPTOR_CODE
, B.ENDORSER_CODE
, B.CURRENCY
, B.INTEREST_RATE
FROM XTR_PARCEL_SPLITS A
, XTR_DEALS_V B
WHERE A.STATUS_CODE = 'CURRENT'
AND A.PARCEL_REMAINING > 0
AND B.DEAL_NO = A.DEAL_NO
Columns
Name |
DEAL_NO |
FACE_VALUE_AMOUNT |
RESERVE_PARCEL |
PARCEL_SIZE |
AVAILABLE_FOR_RESALE |
PARCEL_REMAINING |
STATUS_CODE |
DEAL_SUBTYPE |
ACCEPTOR_CODE |
ENDORSER_CODE |
CURRENCY |
INTEREST_RATE |