VIEW: PA.PA_INTEGRATION_OPTIONS#

Source

View Text - Preformatted

select INTEGRATION_OPTION_NAME INTEGRATION_OPTION_NAME, DESCRIPTION DESCRIPTION, ENABLED_FLAG ENABLED_FLAG, CURRENCY_CODE CURRENCY_CODE, RATE_TYPE_CODE RATE_TYPE_CODE, RATE_DATE_TYPE RATE_DATE_TYPE, RATE_DATE RATE_DATE, PLANNING_RESOURCE_LIST_ID PLANNING_RESOURCE_LIST_ID, EMP_BILL_RATE_SCH_ID EMP_BILL_RATE_SCH_ID, JOB_BILL_RATE_SCH_ID JOB_BILL_RATE_SCH_ID, NON_LABOR_BILL_RATE_SCH_ID NON_LABOR_BILL_RATE_SCH_ID, RES_CLASS_BILL_RATE_SCH_ID RES_CLASS_BILL_RATE_SCH_ID, INTEGRATION_BATCH_SIZE INTEGRATION_BATCH_SIZE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_INTEGRATION_DATE LAST_INTEGRATION_DATE, RESOURCE_SYNCED RESOURCE_SYNCED, INTEGRATION_PROCESS_STATUS INTEGRATION_PROCESS_STATUS from "PA"."PA_INTEGRATION_OPTIONS"

View Text - HTML Formatted

SELECT INTEGRATION_OPTION_NAME INTEGRATION_OPTION_NAME
, DESCRIPTION DESCRIPTION
, ENABLED_FLAG ENABLED_FLAG
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE_CODE RATE_TYPE_CODE
, RATE_DATE_TYPE RATE_DATE_TYPE
, RATE_DATE RATE_DATE
, PLANNING_RESOURCE_LIST_ID PLANNING_RESOURCE_LIST_ID
, EMP_BILL_RATE_SCH_ID EMP_BILL_RATE_SCH_ID
, JOB_BILL_RATE_SCH_ID JOB_BILL_RATE_SCH_ID
, NON_LABOR_BILL_RATE_SCH_ID NON_LABOR_BILL_RATE_SCH_ID
, RES_CLASS_BILL_RATE_SCH_ID RES_CLASS_BILL_RATE_SCH_ID
, INTEGRATION_BATCH_SIZE INTEGRATION_BATCH_SIZE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_INTEGRATION_DATE LAST_INTEGRATION_DATE
, RESOURCE_SYNCED RESOURCE_SYNCED
, INTEGRATION_PROCESS_STATUS INTEGRATION_PROCESS_STATUS
FROM "PA"."PA_INTEGRATION_OPTIONS"