[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 |
APPS.XTR_P_SPLIT_V