PJS_ALLOC_FP_PROJ_F_V

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name
PROJECT_ID RBS_VERSION_ID RBS_ELEMENT_ID PROJECT_ELEMENT_ID PERIOD_SET_NAME PERIOD_TYPE PERIOD_NAME REVENUE RAW_COST BRDN_COST LABOR_HRS BILL_RAW_COST BILL_BRDN_COST BILL_LABOR_HRS CAP_BRDN_COST CAP_RAW_COST CALENDAR_TYPE CURRENCY_TYPE

Query

SQL_Statement

SELECT fin.PROJECT_ID PROJECT_ID ,fin.RBS_VERSION_ID RBS_VERSION_ID ,nvl(decode(fin.RBS_VERSION_ID, 0, 0, accum.RBS_ELEMENT_ID), 1) RBS_ELEMENT_ID ,fin.PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID ,cal.PERIOD_SET_NAME PERIOD_SET_NAME ,cal.PERIOD_TYPE PERIOD_TYPE ,tim.CAL_PERIOD_NAME PERIOD_NAME ,sum(fin.REVENUE) REVENUE ,sum(fin.RAW_COST) RAW_COST ,sum(fin.BRDN_COST) BRDN_COST ,sum(fin.LABOR_HRS) LABOR_HRS ,sum(fin.BILL_RAW_COST) BILL_RAW_COST ,sum(fin.BILL_BRDN_COST) BILL_BRDN_COST ,sum(fin.BILL_LABOR_HRS) BILL_LABOR_HRS ,sum(fin.CAP_BRDN_COST) CAP_BRDN_COST ,sum(fin.CAP_RAW_COST) CAP_RAW_COST ,fin.CALENDAR_TYPE CALENDAR_TYPE ,fin.currency_type FROM ( SELECT fin.PROJECT_ID PROJECT_ID ,fin.TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID ,fin.TASK_ID PROJECT_ELEMENT_ID ,hdr.RBS_VERSION_ID RBS_VERSION_ID ,fin.PERIOD_NAME PERIOD_NAME ,fin.CALENDAR_ID CALENDAR_ID ,fin.CALENDAR_TYPE CALENDAR_TYPE ,fin.REVENUE REVENUE ,fin.RAW_COST RAW_COST ,fin.BILL_RAW_COST BILL_RAW_COST ,fin.CAP_RAW_COST CAP_RAW_COST ,fin.BRDN_COST BRDN_COST ,fin.BILL_BRDN_COST BILL_BRDN_COST ,fin.CAP_BRDN_COST CAP_BRDN_COST ,decode(fin.RESOURCE_CLASS_ID, 1, fin.QUANTITY, to_number(NULL)) LABOR_HRS ,decode(fin.RESOURCE_CLASS_ID, 1, fin.BILL_QUANTITY, to_number(NULL)) BILL_LABOR_HRS ,fin.currency_type FROM PJS_FP_BASE_FIN fin ,PJS_RBS_HEADER hdr WHERE fin.PROJECT_ID = hdr.PROJECT_ID ) fin ,PJF_RBS_TXN_ACCUM_MAP accum ,PJS_TIME_D TIM ,PJS_TIME_CAL_NAME CAL WHERE fin.TXN_ACCUM_HEADER_ID = accum.TXN_ACCUM_HEADER_ID(+) AND fin.RBS_VERSION_ID = accum.RBS_VERSION_ID(+) AND fin.calendar_id = cal.calendar_id AND fin.calendar_id = tim.calendar_id AND fin.period_name = tim.cal_period_name GROUP BY fin.PROJECT_ID ,fin.PROJECT_ELEMENT_ID ,fin.RBS_VERSION_ID ,nvl(decode(fin.RBS_VERSION_ID, 0, 0, accum.RBS_ELEMENT_ID), 1) ,fin.CALENDAR_TYPE ,cal.PERIOD_SET_NAME ,cal.PERIOD_TYPE ,tim.CAL_PERIOD_name ,fin.currency_type