View: OKC_TERMS_TEMPLATES

View Text

SELECT TTA.TEMPLATE_ID
, DECODE(ORIG_SYSTEM_REFERENCE_CODE
, 'OKC11510UPG'
, OKC_UTIL.DECODE_LOOKUP('OKC_11510_MIG_TEMPLATES'
, TTA.TEMPLATE_NAME)
, TTA.TEMPLATE_NAME) TEMPLATE_NAME
, TTA.WORKING_COPY_FLAG
, TTA.INTENT
, TTA.STATUS_CODE
, TTA.START_DATE
, TTA.END_DATE
, TTA.GLOBAL_FLAG
, TTA.PARENT_TEMPLATE_ID
, TTA.CONTRACT_EXPERT_ENABLED
, TTA.TEMPLATE_MODEL_ID
, TTA.INSTRUCTION_TEXT
, TTA.TMPL_NUMBERING_SCHEME
, TTA.PRINT_TEMPLATE_ID
, TTA.DESCRIPTION
, TTA.CREATED_BY CREATED_BY
, TTA.CREATION_DATE CREATION_DATE
, TTA.LAST_UPDATED_BY LAST_UPDATED_BY
, TTA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TTA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TTA.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TTA.HIDE_YN HIDE_YN
, TTA.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TTA.ATTRIBUTE1 ATTRIBUTE1
, TTA.ATTRIBUTE2 ATTRIBUTE2
, TTA.ATTRIBUTE3 ATTRIBUTE3
, TTA.ATTRIBUTE4 ATTRIBUTE4
, TTA.ATTRIBUTE5 ATTRIBUTE5
, TTA.ATTRIBUTE6 ATTRIBUTE6
, TTA.ATTRIBUTE7 ATTRIBUTE7
, TTA.ATTRIBUTE8 ATTRIBUTE8
, TTA.ATTRIBUTE9 ATTRIBUTE9
, TTA.ATTRIBUTE10 ATTRIBUTE10
, TTA.ATTRIBUTE11 ATTRIBUTE11
, TTA.ATTRIBUTE12 ATTRIBUTE12
, TTA.ATTRIBUTE13 ATTRIBUTE13
, TTA.ATTRIBUTE14 ATTRIBUTE14
, TTA.ATTRIBUTE15 ATTRIBUTE15
FROM OKC_TERMS_TEMPLATES_ALL TTA
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns