VIEW: APPS.CZ_UI_PATHED_IMAGES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'