VIEW: APPS.PJI_ACT_CMT_BY_PERIOD_V

Source

View Text - Preformatted

SELECT PABR.PROJECT_ID PROJECT_ID, PABR.TASK_ID TASK_ID, PABR.PERIOD_NAME PERIOD_NAME, PABR.PERIOD_START_DATE PERIOD_START_DATE, PABR.PERIOD_END_DATE PERIOD_END_DATE, PABR.REVENUE REVENUE, PABR.RAW_COST RAW_COST, PABR.CAPITAL_RAW_COST CAPITAL_RAW_COST, PABR.BURDENED_COST BURDENED_COST, PABR.CAPITAL_BURDENED_COST CAPITAL_BURDENED_COST, PABR.RBS_ELEMENT_ID RBS_ELEMENT_ID, PABR.RBS_VERSION_ID RBS_VERSION_ID, PABR.CALENDAR_TYPE CALENDAR_TYPE, PABR.QUANTITY QUANTITY, PABR.BILLABLE_QUANTITY BILLABLE_QUANTITY, PABR.LABOR_HRS LABOR_HRS , PABR.BILL_LABOR_HRS BILL_LABOR_HRS, PABR.BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST, PABR.BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST, PABR.EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST , PABR.EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST, PABR.LABOR_RAW_COST LABOR_RAW_COST, PABR.LABOR_BRDN_COST LABOR_BRDN_COST, PABR.LABOR_REVENUE LABOR_REVENUE, PABR.EQUIPMENT_HOURS EQUIPMENT_HOURS, PABR.BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS, PABR.CMT_QUANTITY CMT_QUANTITY, PABR.SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST , PABR.PO_COMMITTED_COST PO_COMMITTED_COST , PABR.PR_COMMITTED_COST PR_COMMITTED_COST , PABR.OTH_COMMITTED_COST OTH_COMMITTED_COST, PABR.CMT_BURDENED_COST CMT_BURDENED_COST FROM PJI_PRD_ACT_CMT_BY_RSRC_V PABR

View Text - HTML Formatted

SELECT PABR.PROJECT_ID PROJECT_ID
, PABR.TASK_ID TASK_ID
, PABR.PERIOD_NAME PERIOD_NAME
, PABR.PERIOD_START_DATE PERIOD_START_DATE
, PABR.PERIOD_END_DATE PERIOD_END_DATE
, PABR.REVENUE REVENUE
, PABR.RAW_COST RAW_COST
, PABR.CAPITAL_RAW_COST CAPITAL_RAW_COST
, PABR.BURDENED_COST BURDENED_COST
, PABR.CAPITAL_BURDENED_COST CAPITAL_BURDENED_COST
, PABR.RBS_ELEMENT_ID RBS_ELEMENT_ID
, PABR.RBS_VERSION_ID RBS_VERSION_ID
, PABR.CALENDAR_TYPE CALENDAR_TYPE
, PABR.QUANTITY QUANTITY
, PABR.BILLABLE_QUANTITY BILLABLE_QUANTITY
, PABR.LABOR_HRS LABOR_HRS
, PABR.BILL_LABOR_HRS BILL_LABOR_HRS
, PABR.BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST
, PABR.BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST
, PABR.EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST
, PABR.EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST
, PABR.LABOR_RAW_COST LABOR_RAW_COST
, PABR.LABOR_BRDN_COST LABOR_BRDN_COST
, PABR.LABOR_REVENUE LABOR_REVENUE
, PABR.EQUIPMENT_HOURS EQUIPMENT_HOURS
, PABR.BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS
, PABR.CMT_QUANTITY CMT_QUANTITY
, PABR.SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST
, PABR.PO_COMMITTED_COST PO_COMMITTED_COST
, PABR.PR_COMMITTED_COST PR_COMMITTED_COST
, PABR.OTH_COMMITTED_COST OTH_COMMITTED_COST
, PABR.CMT_BURDENED_COST CMT_BURDENED_COST
FROM PJI_PRD_ACT_CMT_BY_RSRC_V PABR