VIEW: APPS.OKE_TERMTYPE_ASSIGNED_V

Source

View Text - Preformatted

SELECT -1 , 1 , TT.TERM_TYPE_NAME , 'okeatgrp' , TT.TERM_TYPE_CODE , TT.TERM_TYPE_NAME FROM OKE_TERM_TYPES_V TT UNION ALL SELECT 0 , 2 , T.TERM_NAME , 'okeattr' , RPAD(T.TERM_TYPE_CODE , 30 , ' ') || T.TERM_CODE , RPAD(TT.TERM_TYPE_NAME , 80 , ' ') || T.TERM_NAME FROM OKE_TERMS_VL T , OKE_TERM_TYPES_V TT WHERE T.TERM_TYPE_CODE = TT.TERM_TYPE_CODE

View Text - HTML Formatted

SELECT -1
, 1
, TT.TERM_TYPE_NAME
, 'OKEATGRP'
, TT.TERM_TYPE_CODE
, TT.TERM_TYPE_NAME
FROM OKE_TERM_TYPES_V TT UNION ALL SELECT 0
, 2
, T.TERM_NAME
, 'OKEATTR'
, RPAD(T.TERM_TYPE_CODE
, 30
, ' ') || T.TERM_CODE
, RPAD(TT.TERM_TYPE_NAME
, 80
, ' ') || T.TERM_NAME
FROM OKE_TERMS_VL T
, OKE_TERM_TYPES_V TT
WHERE T.TERM_TYPE_CODE = TT.TERM_TYPE_CODE