Oracle OM Order Type which has enabled Credit Check - Query

SELECT ottl.name,
  otta.end_date_active,
  otta.entry_credit_check_rule_id
FROM apps.oe_transaction_types_all otta,
  apps.oe_transaction_types_tl ottl
WHERE transaction_type_code     ='ORDER'
AND entry_credit_check_rule_id IS NOT NULL
AND (end_date_active           IS NULL
OR end_date_active              > sysdate)
AND otta.transaction_type_id    = ottl.transaction_type_id
ORDER BY ottl.name ASC