[Home] [Help]
View: OKE_TERMTYPE_ASSIGNED_V
Product: | OKE - Project Contracts |
Description: | View for contract terms and conditions that have already been classified |
Implementation/DBA Data: |
APPS.OKE_TERMTYPE_ASSIGNED_V
|
View Text
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
Columns
Name |
INIT_STAT |
DEPTH |
LABEL |
ICON |
DATA |
SORT_KEY |