PJF_PROJ_ELEMENTS_B

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
PROJ_ELEMENT_ID PROJECT_ID OBJECT_TYPE ELEMENT_NUMBER DENORM_TOP_ELEMENT_ID DENORM_WBS_LEVEL DENORM_PARENT_ELEMENT_ID SERVICE_TYPE_CODE CHARGEABLE_FLAG BILLABLE_FLAG LIMIT_TO_TXN_CONTROLS_FLAG START_DATE COMPLETION_DATE LABOR_COST_MULTIPLIER_NAME COST_IND_RATE_SCH_ID COST_IND_SCH_FIXED_DATE ALLOW_CROSS_CHARGE_FLAG CC_PROCESS_LABOR_FLAG LABOR_TP_SCHEDULE_ID LABOR_TP_FIXED_DATE CC_PROCESS_NL_FLAG NL_TP_SCHEDULE_ID NL_TP_FIXED_DATE RECEIVE_PROJECT_INVOICE_FLAG WORK_TYPE_ID RETIREMENT_COST_FLAG CINT_ELIGIBLE_FLAG CINT_STOP_DATE GEN_ETC_SOURCE_CODE CLIN_ELEMENT_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY PM_SOURCE_CODE PM_SOURCE_REFERENCE MANAGER_PERSON_ID CARRYING_OUT_ORGANIZATION_ID LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 PARENT_STRUCTURE_ID OBJECT_VERSION_NUMBER STRUCTURE_TYPE LEAF_NODE_FLAG CREATED_FROM_SOURCE_ID BASELINE_START_DATE BASELINE_FINISH_DATE PLANNING_START_DATE PLANNING_END_DATE ETC_CALC_METHOD PERCENT_COMP_CALC_METHOD SITE_USE_ID PLANNING_DATES_ROLLUP_FLAG CAPITALIZABLE_FLAG DENORM_ELEM_VER_ID DENORM_PARENT_STRUCT_VER_ID DENORM_PARENT_ELEM_VER_ID DENORM_PARENT_OBJECT_TYPE DENORM_WBS_NUMBER DENORM_DISPLAY_SEQUENCE IC_CLIN_ELEMENT_ID CRITICAL_FLAG MILESTONE_FLAG

Name

PROJ_ELEMENT_ID

PROJECT_ID

OBJECT_TYPE

ELEMENT_NUMBER

DENORM_TOP_ELEMENT_ID

DENORM_WBS_LEVEL

DENORM_PARENT_ELEMENT_ID

SERVICE_TYPE_CODE

CHARGEABLE_FLAG

BILLABLE_FLAG

LIMIT_TO_TXN_CONTROLS_FLAG

START_DATE

COMPLETION_DATE

LABOR_COST_MULTIPLIER_NAME

COST_IND_RATE_SCH_ID

COST_IND_SCH_FIXED_DATE

ALLOW_CROSS_CHARGE_FLAG

CC_PROCESS_LABOR_FLAG

LABOR_TP_SCHEDULE_ID

LABOR_TP_FIXED_DATE

CC_PROCESS_NL_FLAG

NL_TP_SCHEDULE_ID

NL_TP_FIXED_DATE

RECEIVE_PROJECT_INVOICE_FLAG

WORK_TYPE_ID

RETIREMENT_COST_FLAG

CINT_ELIGIBLE_FLAG

CINT_STOP_DATE

GEN_ETC_SOURCE_CODE

CLIN_ELEMENT_ID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

PM_SOURCE_CODE

PM_SOURCE_REFERENCE

MANAGER_PERSON_ID

CARRYING_OUT_ORGANIZATION_ID

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

PARENT_STRUCTURE_ID

OBJECT_VERSION_NUMBER

STRUCTURE_TYPE

LEAF_NODE_FLAG

CREATED_FROM_SOURCE_ID

BASELINE_START_DATE

BASELINE_FINISH_DATE

PLANNING_START_DATE

PLANNING_END_DATE

ETC_CALC_METHOD

PERCENT_COMP_CALC_METHOD

SITE_USE_ID

PLANNING_DATES_ROLLUP_FLAG

CAPITALIZABLE_FLAG

DENORM_ELEM_VER_ID

DENORM_PARENT_STRUCT_VER_ID

DENORM_PARENT_ELEM_VER_ID

DENORM_PARENT_OBJECT_TYPE

DENORM_WBS_NUMBER

DENORM_DISPLAY_SEQUENCE

IC_CLIN_ELEMENT_ID

CRITICAL_FLAG

MILESTONE_FLAG

Query

SQL_Statement
SELECT PEB.PROJ_ELEMENT_ID, PEB.PROJECT_ID, PEB.OBJECT_TYPE, PEB.ELEMENT_NUMBER, PEB.DENORM_TOP_ELEMENT_ID, PEB.DENORM_WBS_LEVEL, PEB.DENORM_PARENT_ELEMENT_ID, PEB.SERVICE_TYPE_CODE, PEB.CHARGEABLE_FLAG, PEB.BILLABLE_FLAG, PEB.LIMIT_TO_TXN_CONTROLS_FLAG, PEB.START_DATE, PEB.COMPLETION_DATE, PEB.LABOR_COST_MULTIPLIER_NAME, PEB.COST_IND_RATE_SCH_ID, PEB.COST_IND_SCH_FIXED_DATE, PEB.ALLOW_CROSS_CHARGE_FLAG, PEB.CC_PROCESS_LABOR_FLAG, PEB.LABOR_TP_SCHEDULE_ID, PEB.LABOR_TP_FIXED_DATE, PEB.CC_PROCESS_NL_FLAG, PEB.NL_TP_SCHEDULE_ID, PEB.NL_TP_FIXED_DATE, PEB.RECEIVE_PROJECT_INVOICE_FLAG, PEB.WORK_TYPE_ID, PEB.RETIREMENT_COST_FLAG, PEB.CINT_ELIGIBLE_FLAG, PEB.CINT_STOP_DATE, PEB.GEN_ETC_SOURCE_CODE, PEB.CLIN_ELEMENT_ID, PEB.CREATION_DATE, PEB.CREATED_BY, PEB.LAST_UPDATE_DATE, PEB.LAST_UPDATED_BY, PEB.PM_SOURCE_CODE, PEB.PM_SOURCE_REFERENCE, PEB.MANAGER_PERSON_ID, PEB.CARRYING_OUT_ORGANIZATION_ID, PEB.LAST_UPDATE_LOGIN, PEB.ATTRIBUTE_CATEGORY, PEB.ATTRIBUTE1, PEB.ATTRIBUTE2, PEB.ATTRIBUTE3, PEB.ATTRIBUTE4, PEB.ATTRIBUTE5, PEB.ATTRIBUTE6, PEB.ATTRIBUTE7, PEB.ATTRIBUTE8, PEB.ATTRIBUTE9, PEB.ATTRIBUTE10, PEB.ATTRIBUTE11, PEB.ATTRIBUTE12, PEB.ATTRIBUTE13, PEB.ATTRIBUTE14, PEB.ATTRIBUTE15, PEB.PARENT_STRUCTURE_ID, PEB.OBJECT_VERSION_NUMBER, PEB.STRUCTURE_TYPE, PEB.LEAF_NODE_FLAG, PEB.CREATED_FROM_SOURCE_ID, PEB.BASELINE_START_DATE, PEB.BASELINE_FINISH_DATE, PEB.PLANNING_START_DATE, PEB.PLANNING_END_DATE, PEB.ETC_CALC_METHOD, PEB.PERCENT_COMP_CALC_METHOD, PEB.SITE_USE_ID, PEB.PLANNING_DATES_ROLLUP_FLAG, PEB.CAPITALIZABLE_FLAG, PEB.DENORM_ELEM_VER_ID, PEB.DENORM_PARENT_STRUCT_VER_ID, PEB.DENORM_PARENT_ELEM_VER_ID, PEB.DENORM_PARENT_OBJECT_TYPE, PEB.DENORM_WBS_NUMBER, PEB.DENORM_DISPLAY_SEQUENCE, PEB.IC_CLIN_ELEMENT_ID, PEB.CRITICAL_FLAG, PEB.MILESTONE_FLAG FROM PJF_PROJ_ELEMENTS_B PEB WHERE PEB.ELEMENT_TYPE = 'FINANCIAL'

SQL_Statement

SELECT

PEB.PROJ_ELEMENT_ID,

PEB.PROJECT_ID,

PEB.OBJECT_TYPE,

PEB.ELEMENT_NUMBER,

PEB.DENORM_TOP_ELEMENT_ID,

PEB.DENORM_WBS_LEVEL,

PEB.DENORM_PARENT_ELEMENT_ID,

PEB.SERVICE_TYPE_CODE,

PEB.CHARGEABLE_FLAG,

PEB.BILLABLE_FLAG,

PEB.LIMIT_TO_TXN_CONTROLS_FLAG,

PEB.START_DATE,

PEB.COMPLETION_DATE,

PEB.LABOR_COST_MULTIPLIER_NAME,

PEB.COST_IND_RATE_SCH_ID,

PEB.COST_IND_SCH_FIXED_DATE,

PEB.ALLOW_CROSS_CHARGE_FLAG,

PEB.CC_PROCESS_LABOR_FLAG,

PEB.LABOR_TP_SCHEDULE_ID,

PEB.LABOR_TP_FIXED_DATE,

PEB.CC_PROCESS_NL_FLAG,

PEB.NL_TP_SCHEDULE_ID,

PEB.NL_TP_FIXED_DATE,

PEB.RECEIVE_PROJECT_INVOICE_FLAG,

PEB.WORK_TYPE_ID,

PEB.RETIREMENT_COST_FLAG,

PEB.CINT_ELIGIBLE_FLAG,

PEB.CINT_STOP_DATE,

PEB.GEN_ETC_SOURCE_CODE,

PEB.CLIN_ELEMENT_ID,

PEB.CREATION_DATE,

PEB.CREATED_BY,

PEB.LAST_UPDATE_DATE,

PEB.LAST_UPDATED_BY,

PEB.PM_SOURCE_CODE,

PEB.PM_SOURCE_REFERENCE,

PEB.MANAGER_PERSON_ID,

PEB.CARRYING_OUT_ORGANIZATION_ID,

PEB.LAST_UPDATE_LOGIN,

PEB.ATTRIBUTE_CATEGORY,

PEB.ATTRIBUTE1,

PEB.ATTRIBUTE2,

PEB.ATTRIBUTE3,

PEB.ATTRIBUTE4,

PEB.ATTRIBUTE5,

PEB.ATTRIBUTE6,

PEB.ATTRIBUTE7,

PEB.ATTRIBUTE8,

PEB.ATTRIBUTE9,

PEB.ATTRIBUTE10,

PEB.ATTRIBUTE11,

PEB.ATTRIBUTE12,

PEB.ATTRIBUTE13,

PEB.ATTRIBUTE14,

PEB.ATTRIBUTE15,

PEB.PARENT_STRUCTURE_ID,

PEB.OBJECT_VERSION_NUMBER,

PEB.STRUCTURE_TYPE,

PEB.LEAF_NODE_FLAG,

PEB.CREATED_FROM_SOURCE_ID,

PEB.BASELINE_START_DATE,

PEB.BASELINE_FINISH_DATE,

PEB.PLANNING_START_DATE,

PEB.PLANNING_END_DATE,

PEB.ETC_CALC_METHOD,

PEB.PERCENT_COMP_CALC_METHOD,

PEB.SITE_USE_ID,

PEB.PLANNING_DATES_ROLLUP_FLAG,

PEB.CAPITALIZABLE_FLAG,

PEB.DENORM_ELEM_VER_ID,

PEB.DENORM_PARENT_STRUCT_VER_ID,

PEB.DENORM_PARENT_ELEM_VER_ID,

PEB.DENORM_PARENT_OBJECT_TYPE,

PEB.DENORM_WBS_NUMBER,

PEB.DENORM_DISPLAY_SEQUENCE,

PEB.IC_CLIN_ELEMENT_ID,

PEB.CRITICAL_FLAG,

PEB.MILESTONE_FLAG

FROM

PJF_PROJ_ELEMENTS_B PEB

WHERE PEB.ELEMENT_TYPE = 'FINANCIAL'