VIEW: PA.PA_BILL_RATES_ALL#

Source

View Text - Preformatted

select BILL_RATE_ORGANIZATION_ID BILL_RATE_ORGANIZATION_ID, STD_BILL_RATE_SCHEDULE STD_BILL_RATE_SCHEDULE, 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, START_DATE_ACTIVE START_DATE_ACTIVE, PERSON_ID PERSON_ID, JOB_ID JOB_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, NON_LABOR_RESOURCE NON_LABOR_RESOURCE, RATE RATE, BILL_RATE_UNIT BILL_RATE_UNIT, MARKUP_PERCENTAGE MARKUP_PERCENTAGE, END_DATE_ACTIVE END_DATE_ACTIVE, ORG_ID ORG_ID, BILL_RATE_SCH_ID BILL_RATE_SCH_ID, JOB_GROUP_ID JOB_GROUP_ID, RATE_CURRENCY_CODE RATE_CURRENCY_CODE, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE, RES_CLASS_ORGANIZATION_ID RES_CLASS_ORGANIZATION_ID, INTEGRATION_ID INTEGRATION_ID from "PA"."PA_BILL_RATES_ALL"

View Text - HTML Formatted

SELECT BILL_RATE_ORGANIZATION_ID BILL_RATE_ORGANIZATION_ID
, STD_BILL_RATE_SCHEDULE STD_BILL_RATE_SCHEDULE
, 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
, START_DATE_ACTIVE START_DATE_ACTIVE
, PERSON_ID PERSON_ID
, JOB_ID JOB_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, RATE RATE
, BILL_RATE_UNIT BILL_RATE_UNIT
, MARKUP_PERCENTAGE MARKUP_PERCENTAGE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ORG_ID ORG_ID
, BILL_RATE_SCH_ID BILL_RATE_SCH_ID
, JOB_GROUP_ID JOB_GROUP_ID
, RATE_CURRENCY_CODE RATE_CURRENCY_CODE
, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE
, RES_CLASS_ORGANIZATION_ID RES_CLASS_ORGANIZATION_ID
, INTEGRATION_ID INTEGRATION_ID
FROM "PA"."PA_BILL_RATES_ALL"