VIEW: PA.PA_CI_DIRECT_COST_DETAILS#

Source

View Text - Preformatted

select DC_LINE_ID DC_LINE_ID, CI_ID CI_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, UNIT_OF_MEASURE UNIT_OF_MEASURE, CURRENCY_CODE CURRENCY_CODE, QUANTITY QUANTITY, PLANNING_RESOURCE_RATE PLANNING_RESOURCE_RATE, RAW_COST RAW_COST, BURDENED_COST BURDENED_COST, RAW_COST_RATE RAW_COST_RATE, BURDEN_COST_RATE BURDEN_COST_RATE, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, CHANGE_REASON_CODE CHANGE_REASON_CODE, CHANGE_DESCRIPTION CHANGE_DESCRIPTION, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_BY LAST_UPDATE_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_CI_DIRECT_COST_DETAILS"

View Text - HTML Formatted

SELECT DC_LINE_ID DC_LINE_ID
, CI_ID CI_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, CURRENCY_CODE CURRENCY_CODE
, QUANTITY QUANTITY
, PLANNING_RESOURCE_RATE PLANNING_RESOURCE_RATE
, RAW_COST RAW_COST
, BURDENED_COST BURDENED_COST
, RAW_COST_RATE RAW_COST_RATE
, BURDEN_COST_RATE BURDEN_COST_RATE
, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, CHANGE_REASON_CODE CHANGE_REASON_CODE
, CHANGE_DESCRIPTION CHANGE_DESCRIPTION
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_BY LAST_UPDATE_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_CI_DIRECT_COST_DETAILS"