VIEW: WIP.WIP_PAC_ACTUAL_COST_DETAILS#

Source

View Text - Preformatted

select PAC_PERIOD_ID PAC_PERIOD_ID, COST_GROUP_ID COST_GROUP_ID, COST_TYPE_ID COST_TYPE_ID, TRANSACTION_ID TRANSACTION_ID, LEVEL_TYPE LEVEL_TYPE, COST_ELEMENT_ID COST_ELEMENT_ID, RESOURCE_ID RESOURCE_ID, BASIS_RESOURCE_ID BASIS_RESOURCE_ID, TRANSACTION_COSTED_DATE TRANSACTION_COSTED_DATE, ACTUAL_COST ACTUAL_COST, ACTUAL_VALUE ACTUAL_VALUE, BASIS_TYPE BASIS_TYPE, BASIS_UNITS BASIS_UNITS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "WIP"."WIP_PAC_ACTUAL_COST_DETAILS"

View Text - HTML Formatted

SELECT PAC_PERIOD_ID PAC_PERIOD_ID
, COST_GROUP_ID COST_GROUP_ID
, COST_TYPE_ID COST_TYPE_ID
, TRANSACTION_ID TRANSACTION_ID
, LEVEL_TYPE LEVEL_TYPE
, COST_ELEMENT_ID COST_ELEMENT_ID
, RESOURCE_ID RESOURCE_ID
, BASIS_RESOURCE_ID BASIS_RESOURCE_ID
, TRANSACTION_COSTED_DATE TRANSACTION_COSTED_DATE
, ACTUAL_COST ACTUAL_COST
, ACTUAL_VALUE ACTUAL_VALUE
, BASIS_TYPE BASIS_TYPE
, BASIS_UNITS BASIS_UNITS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "WIP"."WIP_PAC_ACTUAL_COST_DETAILS"