DBA Data[Home] [Help]

VIEW: APPS.FRM_DELIVERY_FTP_SERVERS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID,
B.SERVER_ID,
T.SERVER_NAME,
B.HOST,
B.PORT,
B.USERNAME,
B.TYPE,
B.FILE_PERMISSION,
B.AUTH_TYPE,
B.OBJECT_VERSION_NUMBER,
B.CREATION_DATE,
B.CREATED_BY,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_LOGIN,
B.LAST_UPDATE_DATE
FROM FRM_DELIVERY_FTP_SERVERS_B B,
FRM_DELIVERY_FTP_SERVERS_TL T
WHERE 
B.SERVER_ID = T.SERVER_ID 
AND T.LANGUAGE=USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.SERVER_ID
, T.SERVER_NAME
, B.HOST
, B.PORT
, B.USERNAME
, B.TYPE
, B.FILE_PERMISSION
, B.AUTH_TYPE
, B.OBJECT_VERSION_NUMBER
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE FROM FRM_DELIVERY_FTP_SERVERS_B B
, FRM_DELIVERY_FTP_SERVERS_TL T WHERE B.SERVER_ID = T.SERVER_ID AND T.LANGUAGE=USERENV('LANG')