VIEW: APPS.ASG_APPLICATION_VL

Source

View Text - Preformatted

SELECT B.MOBILE_APPLICATION_ID MOBILE_APPLICATION_ID, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.DEVICE_TYPE DEVICE_TYPE, B.APP_VERSION APP_VERSION, B.STATUS STATUS, B.FLASH_MESSAGE_LENGTH FLASH_MESSAGE_LENGTH, B.APPLICATION_CODE APPLICATION_CODE, B.SYNCHRONIZATION_FLAG SYNCHRONIZATION_FLAG, B.SMS SMS, B.EMAIL EMAIL, TL.MOBILE_APPLICATION_NAME MOBILE_APPLICATION_NAME FROM ASG_APPLICATIONS_B B ,ASG_APPLICATIONS_TL TL WHERE B.MOBILE_APPLICATION_ID = TL.MOBILE_APPLICATION_ID AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.MOBILE_APPLICATION_ID MOBILE_APPLICATION_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.DEVICE_TYPE DEVICE_TYPE
, B.APP_VERSION APP_VERSION
, B.STATUS STATUS
, B.FLASH_MESSAGE_LENGTH FLASH_MESSAGE_LENGTH
, B.APPLICATION_CODE APPLICATION_CODE
, B.SYNCHRONIZATION_FLAG SYNCHRONIZATION_FLAG
, B.SMS SMS
, B.EMAIL EMAIL
, TL.MOBILE_APPLICATION_NAME MOBILE_APPLICATION_NAME
FROM ASG_APPLICATIONS_B B
, ASG_APPLICATIONS_TL TL
WHERE B.MOBILE_APPLICATION_ID = TL.MOBILE_APPLICATION_ID
AND TL.LANGUAGE = USERENV('LANG')