Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT COMPANY_CODE
, CPARTY_CODE
, LIMIT_CODE
, COMMITMENT_FEE_PERCENT
, UTILISATION_FEE_PERCENT
, BENCHMARK_REF
, UTILISATION_CALC_BASIS
, UTILIZATION_STRUCTURE_BASIS
, UTILISED_AMOUNT
, LIMIT_AMOUNT
, DECODE(NVL(UTILISATION_CALC_BASIS
, 'A')
, 'U'
, NVL(COMMITMENT_FEE_PERCENT
, 0) + NVL(UTILISATION_FEE_PERCENT
, 0)
, 0) UNDRAWN_ORDER
, DECODE(NVL(UTILISATION_CALC_BASIS
, 'A')
, 'U'
, 0
, NVL(COMMITMENT_FEE_PERCENT
, 0) + NVL(UTILISATION_FEE_PERCENT
, 0)) DRAWN_ORDER FROM XTR_COUNTERPARTY_LIMITS WHERE LIMIT_CODE != 'SETTLE' AND NVL(LIMIT_AMOUNT
, 0) - NVL(UTILISED_AMOUNT
, 0) > 0