VIEW: PA.PA_RES_ASSIGNMENTS_AR#

Source

View Text - Preformatted

select BUDGET_VERSION_ID BUDGET_VERSION_ID, 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, PROJECT_ID PROJECT_ID, PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_PROJECT_ID PURGE_PROJECT_ID, PURGE_RELEASE PURGE_RELEASE, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, TASK_ID TASK_ID, TRACK_AS_LABOR_FLAG TRACK_AS_LABOR_FLAG, UNIT_OF_MEASURE UNIT_OF_MEASURE, STANDARD_BILL_RATE STANDARD_BILL_RATE, AVERAGE_BILL_RATE AVERAGE_BILL_RATE, AVERAGE_COST_RATE AVERAGE_COST_RATE, PROJECT_ASSIGNMENT_ID PROJECT_ASSIGNMENT_ID, PLAN_ERROR_CODE PLAN_ERROR_CODE, TOTAL_PLAN_REVENUE TOTAL_PLAN_REVENUE, TOTAL_PLAN_RAW_COST TOTAL_PLAN_RAW_COST, TOTAL_PLAN_BURDENED_COST TOTAL_PLAN_BURDENED_COST, TOTAL_PLAN_QUANTITY TOTAL_PLAN_QUANTITY, AVERAGE_DISCOUNT_PERCENTAGE AVERAGE_DISCOUNT_PERCENTAGE from "PA"."PA_RES_ASSIGNMENTS_AR"

View Text - HTML Formatted

SELECT BUDGET_VERSION_ID BUDGET_VERSION_ID
, 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
, PROJECT_ID PROJECT_ID
, PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PURGE_RELEASE PURGE_RELEASE
, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, TASK_ID TASK_ID
, TRACK_AS_LABOR_FLAG TRACK_AS_LABOR_FLAG
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, STANDARD_BILL_RATE STANDARD_BILL_RATE
, AVERAGE_BILL_RATE AVERAGE_BILL_RATE
, AVERAGE_COST_RATE AVERAGE_COST_RATE
, PROJECT_ASSIGNMENT_ID PROJECT_ASSIGNMENT_ID
, PLAN_ERROR_CODE PLAN_ERROR_CODE
, TOTAL_PLAN_REVENUE TOTAL_PLAN_REVENUE
, TOTAL_PLAN_RAW_COST TOTAL_PLAN_RAW_COST
, TOTAL_PLAN_BURDENED_COST TOTAL_PLAN_BURDENED_COST
, TOTAL_PLAN_QUANTITY TOTAL_PLAN_QUANTITY
, AVERAGE_DISCOUNT_PERCENTAGE AVERAGE_DISCOUNT_PERCENTAGE
FROM "PA"."PA_RES_ASSIGNMENTS_AR"