VIEW: APPS.CSF_GPS_VENDORS_VL

Source

View Text - Preformatted

SELECT gb.vendor_id , gb.object_version_number , gt.vendor_name , gt.description , gb.implementing_class_name , gb.implementing_pkg_name , gb.service_provider_url , gb.username , gb.password , gb.enabled , gb.usage_interval , gb.validated , gb.validation_details , gb.lease_start_time , gb.created_by , gb.creation_date , gb.last_updated_by , gb.last_update_date , gb.last_update_login FROM csf_gps_vendors_b gb , csf_gps_vendors_tl gt WHERE gb.vendor_id = gt.vendor_id and gt.language = userenv('LANG')

View Text - HTML Formatted

SELECT GB.VENDOR_ID
, GB.OBJECT_VERSION_NUMBER
, GT.VENDOR_NAME
, GT.DESCRIPTION
, GB.IMPLEMENTING_CLASS_NAME
, GB.IMPLEMENTING_PKG_NAME
, GB.SERVICE_PROVIDER_URL
, GB.USERNAME
, GB.PASSWORD
, GB.ENABLED
, GB.USAGE_INTERVAL
, GB.VALIDATED
, GB.VALIDATION_DETAILS
, GB.LEASE_START_TIME
, GB.CREATED_BY
, GB.CREATION_DATE
, GB.LAST_UPDATED_BY
, GB.LAST_UPDATE_DATE
, GB.LAST_UPDATE_LOGIN
FROM CSF_GPS_VENDORS_B GB
, CSF_GPS_VENDORS_TL GT
WHERE GB.VENDOR_ID = GT.VENDOR_ID
AND GT.LANGUAGE = USERENV('LANG')