[Home] [Help]
View: CZ_UI_PATHED_IMAGES_V
View Text
SELECT UI_DEF_ID
, MASTER_TEMPLATE_FLAG
, IMAGE_USAGE_CODE
, ENTITY_CODE
, IMAGE_FILE
, DECODE (( INSTR (SUBSTR (IMAGE_FILE
, 1
, 1)
, '/') + INSTR (SUBSTR (IMAGE_FILE
, 1
, 10)
, '://') )
, 0
, ('/OA_MEDIA/')) || IMAGE_FILE AS FULL_IMAGE_PATH
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, SEEDED_FLAG
, DELETED_FLAG
FROM CZ_UI_IMAGES
WHERE DELETED_FLAG = '0'
Columns
Name |
UI_DEF_ID |
MASTER_TEMPLATE_FLAG |
IMAGE_USAGE_CODE |
ENTITY_CODE |
IMAGE_FILE |
FULL_IMAGE_PATH |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
CREATED_BY |
LAST_UPDATED_BY |
CREATION_DATE |
SEEDED_FLAG |
DELETED_FLAG |