eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ASG_APPLICATION_VL

Product:	ASG - CRM Gateway for Mobile Devices
Description:	MultiLingual view based on ASG_APPLIATIONS_B table.
Implementation/DBA Data:	APPS.ASG_APPLICATION_VL

View Text

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')

Columns

Name
MOBILE_APPLICATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
DEVICE_TYPE
APP_VERSION
STATUS
FLASH_MESSAGE_LENGTH
APPLICATION_CODE
SYNCHRONIZATION_FLAG
SMS
EMAIL
MOBILE_APPLICATION_NAME