VIEW: AP.AP_WEB_PREFERENCES#

Source

View Text - Preformatted

select EMPLOYEE_ID EMPLOYEE_ID, DEFAULT_APPROVER_ID DEFAULT_APPROVER_ID, DEFAULT_EXPENSE_TEMPLATE_ID DEFAULT_EXPENSE_TEMPLATE_ID, DEFAULT_PURPOSE DEFAULT_PURPOSE, VALIDATE_DETAILS_FLAG VALIDATE_DETAILS_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DEFAULT_FOREIGN_CURR_FLAG DEFAULT_FOREIGN_CURR_FLAG, DEFAULT_SOURCE DEFAULT_SOURCE, DEFAULT_LOCATION_ID DEFAULT_LOCATION_ID, VEHICLE_CATEGORY VEHICLE_CATEGORY, VEHICLE_TYPE VEHICLE_TYPE, FUEL_TYPE FUEL_TYPE, TIME_FORMAT TIME_FORMAT, DEFAULT_EXCHANGE_RATE_FLAG DEFAULT_EXCHANGE_RATE_FLAG, SHOW_AUDIT_HEADER_FLAG SHOW_AUDIT_HEADER_FLAG, EXPENSE_ALLOCATIONS_FLAG EXPENSE_ALLOCATIONS_FLAG from "AP"."AP_WEB_PREFERENCES"

View Text - HTML Formatted

SELECT EMPLOYEE_ID EMPLOYEE_ID
, DEFAULT_APPROVER_ID DEFAULT_APPROVER_ID
, DEFAULT_EXPENSE_TEMPLATE_ID DEFAULT_EXPENSE_TEMPLATE_ID
, DEFAULT_PURPOSE DEFAULT_PURPOSE
, VALIDATE_DETAILS_FLAG VALIDATE_DETAILS_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DEFAULT_FOREIGN_CURR_FLAG DEFAULT_FOREIGN_CURR_FLAG
, DEFAULT_SOURCE DEFAULT_SOURCE
, DEFAULT_LOCATION_ID DEFAULT_LOCATION_ID
, VEHICLE_CATEGORY VEHICLE_CATEGORY
, VEHICLE_TYPE VEHICLE_TYPE
, FUEL_TYPE FUEL_TYPE
, TIME_FORMAT TIME_FORMAT
, DEFAULT_EXCHANGE_RATE_FLAG DEFAULT_EXCHANGE_RATE_FLAG
, SHOW_AUDIT_HEADER_FLAG SHOW_AUDIT_HEADER_FLAG
, EXPENSE_ALLOCATIONS_FLAG EXPENSE_ALLOCATIONS_FLAG
FROM "AP"."AP_WEB_PREFERENCES"