eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PJI.PJI_FP_AGGR_PJP0#

Source

View Text - Preformatted


select WORKER_ID WORKER_ID, TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID, TIME_ID TIME_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, CALENDAR_TYPE CALENDAR_TYPE, RBS_AGGR_LEVEL RBS_AGGR_LEVEL, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID, CURRENCY_CODE CURRENCY_CODE, RBS_ELEMENT_ID RBS_ELEMENT_ID, RBS_VERSION_ID RBS_VERSION_ID, PLAN_VERSION_ID PLAN_VERSION_ID, PLAN_TYPE_ID PLAN_TYPE_ID, RAW_COST RAW_COST, BRDN_COST BRDN_COST, REVENUE REVENUE, BILL_RAW_COST BILL_RAW_COST, BILL_BRDN_COST BILL_BRDN_COST, BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST, BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST, BILL_LABOR_HRS BILL_LABOR_HRS, EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST, EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST, CAPITALIZABLE_RAW_COST CAPITALIZABLE_RAW_COST, CAPITALIZABLE_BRDN_COST CAPITALIZABLE_BRDN_COST, LABOR_RAW_COST LABOR_RAW_COST, LABOR_BRDN_COST LABOR_BRDN_COST, LABOR_HRS LABOR_HRS, LABOR_REVENUE LABOR_REVENUE, EQUIPMENT_HOURS EQUIPMENT_HOURS, BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS, SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST, PO_COMMITTED_COST PO_COMMITTED_COST, PR_COMMITTED_COST PR_COMMITTED_COST, OTH_COMMITTED_COST OTH_COMMITTED_COST from "PJI"."PJI_FP_AGGR_PJP0"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID
, TIME_ID TIME_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, CALENDAR_TYPE CALENDAR_TYPE
, RBS_AGGR_LEVEL RBS_AGGR_LEVEL
, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG
, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG
, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID
, CURRENCY_CODE CURRENCY_CODE
, RBS_ELEMENT_ID RBS_ELEMENT_ID
, RBS_VERSION_ID RBS_VERSION_ID
, PLAN_VERSION_ID PLAN_VERSION_ID
, PLAN_TYPE_ID PLAN_TYPE_ID
, RAW_COST RAW_COST
, BRDN_COST BRDN_COST
, REVENUE REVENUE
, BILL_RAW_COST BILL_RAW_COST
, BILL_BRDN_COST BILL_BRDN_COST
, BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST
, BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST
, BILL_LABOR_HRS BILL_LABOR_HRS
, EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST
, EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST
, CAPITALIZABLE_RAW_COST CAPITALIZABLE_RAW_COST
, CAPITALIZABLE_BRDN_COST CAPITALIZABLE_BRDN_COST
, LABOR_RAW_COST LABOR_RAW_COST
, LABOR_BRDN_COST LABOR_BRDN_COST
, LABOR_HRS LABOR_HRS
, LABOR_REVENUE LABOR_REVENUE
, EQUIPMENT_HOURS EQUIPMENT_HOURS
, BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS
, SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST
, PO_COMMITTED_COST PO_COMMITTED_COST
, PR_COMMITTED_COST PR_COMMITTED_COST
, OTH_COMMITTED_COST OTH_COMMITTED_COST
FROM "PJI"."PJI_FP_AGGR_PJP0"