PJF_PROJ_ELEMENTS

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
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 NAME DESCRIPTION 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 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE31 ATTRIBUTE32 ATTRIBUTE33 ATTRIBUTE34 ATTRIBUTE35 ATTRIBUTE36 ATTRIBUTE37 ATTRIBUTE38 ATTRIBUTE39 ATTRIBUTE40 ATTRIBUTE41 ATTRIBUTE42 ATTRIBUTE43 ATTRIBUTE44 ATTRIBUTE45 ATTRIBUTE46 ATTRIBUTE47 ATTRIBUTE48 ATTRIBUTE49 ATTRIBUTE50 ATTRIBUTE1_NUMBER ATTRIBUTE2_NUMBER ATTRIBUTE3_NUMBER ATTRIBUTE4_NUMBER ATTRIBUTE5_NUMBER ATTRIBUTE6_NUMBER ATTRIBUTE7_NUMBER ATTRIBUTE8_NUMBER ATTRIBUTE9_NUMBER ATTRIBUTE10_NUMBER ATTRIBUTE11_NUMBER ATTRIBUTE12_NUMBER ATTRIBUTE13_NUMBER ATTRIBUTE14_NUMBER ATTRIBUTE15_NUMBER ATTRIBUTE1_DATE ATTRIBUTE2_DATE ATTRIBUTE3_DATE ATTRIBUTE4_DATE ATTRIBUTE5_DATE ATTRIBUTE6_DATE ATTRIBUTE7_DATE ATTRIBUTE8_DATE ATTRIBUTE9_DATE ATTRIBUTE10_DATE ATTRIBUTE11_DATE ATTRIBUTE12_DATE ATTRIBUTE13_DATE ATTRIBUTE14_DATE ATTRIBUTE15_DATE PARENT_STRUCTURE_ID OBJECT_VERSION_NUMBER STRUCTURE_TYPE LEAF_NODE_FLAG CREATED_FROM_SOURCE_ID PLANNING_START_DATE PLANNING_END_DATE BASELINE_START_DATE BASELINE_FINISH_DATE PERCENT_COMP_CALC_METHOD ETC_CALC_METHOD SITE_USE_ID PLANNING_DATES_ROLLUP_FLAG CAPITALIZABLE_FLAG DENORM_PARENT_STRUCT_VER_ID DENORM_PARENT_ELEM_VER_ID DENORM_PARENT_OBJECT_TYPE DENORM_WBS_NUMBER DENORM_DISPLAY_SEQUENCE IC_CLIN_ELEMENT_ID DENORM_ELEM_VER_ID PROJ_ELEMENT_ID CRITICAL_FLAG MILESTONE_FLAG OVR_COST_IND_RATE_SCH_ID TASK_TYPE_CODE PRIMARY_RESOURCE_ID TASK_CODE01_ID TASK_CODE02_ID TASK_CODE03_ID TASK_CODE04_ID TASK_CODE05_ID TASK_CODE06_ID TASK_CODE07_ID TASK_CODE08_ID TASK_CODE09_ID TASK_CODE10_ID TASK_CODE11_ID TASK_CODE12_ID TASK_CODE13_ID TASK_CODE14_ID TASK_CODE15_ID TASK_CODE16_ID TASK_CODE17_ID TASK_CODE18_ID TASK_CODE19_ID TASK_CODE20_ID TASK_CODE21_ID TASK_CODE22_ID TASK_CODE23_ID TASK_CODE24_ID TASK_CODE25_ID TASK_CODE26_ID TASK_CODE27_ID TASK_CODE28_ID TASK_CODE29_ID TASK_CODE30_ID TASK_CODE31_ID TASK_CODE32_ID TASK_CODE33_ID TASK_CODE34_ID TASK_CODE35_ID TASK_CODE36_ID TASK_CODE37_ID TASK_CODE38_ID TASK_CODE39_ID TASK_CODE40_ID NUMBER_ATTR01 NUMBER_ATTR02 NUMBER_ATTR03 NUMBER_ATTR04 NUMBER_ATTR05 NUMBER_ATTR06 NUMBER_ATTR07 NUMBER_ATTR08 NUMBER_ATTR09 NUMBER_ATTR10 TEXT_ATTR01 TEXT_ATTR02 TEXT_ATTR03 TEXT_ATTR04 TEXT_ATTR05 TEXT_ATTR06 TEXT_ATTR07 TEXT_ATTR08 TEXT_ATTR09 TEXT_ATTR10 TEXT_ATTR11 TEXT_ATTR12 TEXT_ATTR13 TEXT_ATTR14 TEXT_ATTR15 TEXT_ATTR16 TEXT_ATTR17 TEXT_ATTR18 TEXT_ATTR19 TEXT_ATTR20 ISSUE_ID OBJECT_ASSOCIATION_BITMAP TASK_STATUS_CODE RQMT_ID SPRINT_ID EXTERNAL_ID LAST_VIEWED_DATE DENORM_EXECUTION_DISP_SEQ ELEMENT_TYPE USER_DEFINED_TASK_TYPE IS_INTEGRATED LAST_SYNC_DATE GATE_FLAG CTRL_MS_DATES_FLAG CONTRACT_EVENT_ID

Name

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

NAME

DESCRIPTION

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

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

ATTRIBUTE31

ATTRIBUTE32

ATTRIBUTE33

ATTRIBUTE34

ATTRIBUTE35

ATTRIBUTE36

ATTRIBUTE37

ATTRIBUTE38

ATTRIBUTE39

ATTRIBUTE40

ATTRIBUTE41

ATTRIBUTE42

ATTRIBUTE43

ATTRIBUTE44

ATTRIBUTE45

ATTRIBUTE46

ATTRIBUTE47

ATTRIBUTE48

ATTRIBUTE49

ATTRIBUTE50

ATTRIBUTE1_NUMBER

ATTRIBUTE2_NUMBER

ATTRIBUTE3_NUMBER

ATTRIBUTE4_NUMBER

ATTRIBUTE5_NUMBER

ATTRIBUTE6_NUMBER

ATTRIBUTE7_NUMBER

ATTRIBUTE8_NUMBER

ATTRIBUTE9_NUMBER

ATTRIBUTE10_NUMBER

ATTRIBUTE11_NUMBER

ATTRIBUTE12_NUMBER

ATTRIBUTE13_NUMBER

ATTRIBUTE14_NUMBER

ATTRIBUTE15_NUMBER

ATTRIBUTE1_DATE

ATTRIBUTE2_DATE

ATTRIBUTE3_DATE

ATTRIBUTE4_DATE

ATTRIBUTE5_DATE

ATTRIBUTE6_DATE

ATTRIBUTE7_DATE

ATTRIBUTE8_DATE

ATTRIBUTE9_DATE

ATTRIBUTE10_DATE

ATTRIBUTE11_DATE

ATTRIBUTE12_DATE

ATTRIBUTE13_DATE

ATTRIBUTE14_DATE

ATTRIBUTE15_DATE

PARENT_STRUCTURE_ID

OBJECT_VERSION_NUMBER

STRUCTURE_TYPE

LEAF_NODE_FLAG

CREATED_FROM_SOURCE_ID

PLANNING_START_DATE

PLANNING_END_DATE

BASELINE_START_DATE

BASELINE_FINISH_DATE

PERCENT_COMP_CALC_METHOD

ETC_CALC_METHOD

SITE_USE_ID

PLANNING_DATES_ROLLUP_FLAG

CAPITALIZABLE_FLAG

DENORM_PARENT_STRUCT_VER_ID

DENORM_PARENT_ELEM_VER_ID

DENORM_PARENT_OBJECT_TYPE

DENORM_WBS_NUMBER

DENORM_DISPLAY_SEQUENCE

IC_CLIN_ELEMENT_ID

DENORM_ELEM_VER_ID

PROJ_ELEMENT_ID

CRITICAL_FLAG

MILESTONE_FLAG

OVR_COST_IND_RATE_SCH_ID

TASK_TYPE_CODE

PRIMARY_RESOURCE_ID

TASK_CODE01_ID

TASK_CODE02_ID

TASK_CODE03_ID

TASK_CODE04_ID

TASK_CODE05_ID

TASK_CODE06_ID

TASK_CODE07_ID

TASK_CODE08_ID

TASK_CODE09_ID

TASK_CODE10_ID

TASK_CODE11_ID

TASK_CODE12_ID

TASK_CODE13_ID

TASK_CODE14_ID

TASK_CODE15_ID

TASK_CODE16_ID

TASK_CODE17_ID

TASK_CODE18_ID

TASK_CODE19_ID

TASK_CODE20_ID

TASK_CODE21_ID

TASK_CODE22_ID

TASK_CODE23_ID

TASK_CODE24_ID

TASK_CODE25_ID

TASK_CODE26_ID

TASK_CODE27_ID

TASK_CODE28_ID

TASK_CODE29_ID

TASK_CODE30_ID

TASK_CODE31_ID

TASK_CODE32_ID

TASK_CODE33_ID

TASK_CODE34_ID

TASK_CODE35_ID

TASK_CODE36_ID

TASK_CODE37_ID

TASK_CODE38_ID

TASK_CODE39_ID

TASK_CODE40_ID

NUMBER_ATTR01

NUMBER_ATTR02

NUMBER_ATTR03

NUMBER_ATTR04

NUMBER_ATTR05

NUMBER_ATTR06

NUMBER_ATTR07

NUMBER_ATTR08

NUMBER_ATTR09

NUMBER_ATTR10

TEXT_ATTR01

TEXT_ATTR02

TEXT_ATTR03

TEXT_ATTR04

TEXT_ATTR05

TEXT_ATTR06

TEXT_ATTR07

TEXT_ATTR08

TEXT_ATTR09

TEXT_ATTR10

TEXT_ATTR11

TEXT_ATTR12

TEXT_ATTR13

TEXT_ATTR14

TEXT_ATTR15

TEXT_ATTR16

TEXT_ATTR17

TEXT_ATTR18

TEXT_ATTR19

TEXT_ATTR20

ISSUE_ID

OBJECT_ASSOCIATION_BITMAP

TASK_STATUS_CODE

RQMT_ID

SPRINT_ID

EXTERNAL_ID

LAST_VIEWED_DATE

DENORM_EXECUTION_DISP_SEQ

ELEMENT_TYPE

USER_DEFINED_TASK_TYPE

IS_INTEGRATED

LAST_SYNC_DATE

GATE_FLAG

CTRL_MS_DATES_FLAG

CONTRACT_EVENT_ID

Query

SQL_Statement
SELECT 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, PETL.NAME, PETL.DESCRIPTION, 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.ATTRIBUTE16, PEB.ATTRIBUTE17, PEB.ATTRIBUTE18, PEB.ATTRIBUTE19, PEB.ATTRIBUTE20, PEB.ATTRIBUTE21, PEB.ATTRIBUTE22, PEB.ATTRIBUTE23, PEB.ATTRIBUTE24, PEB.ATTRIBUTE25, PEB.ATTRIBUTE26, PEB.ATTRIBUTE27, PEB.ATTRIBUTE28, PEB.ATTRIBUTE29, PEB.ATTRIBUTE30, PEB.ATTRIBUTE31, PEB.ATTRIBUTE32, PEB.ATTRIBUTE33, PEB.ATTRIBUTE34, PEB.ATTRIBUTE35, PEB.ATTRIBUTE36, PEB.ATTRIBUTE37, PEB.ATTRIBUTE38, PEB.ATTRIBUTE39, PEB.ATTRIBUTE40, PEB.ATTRIBUTE41, PEB.ATTRIBUTE42, PEB.ATTRIBUTE43, PEB.ATTRIBUTE44, PEB.ATTRIBUTE45, PEB.ATTRIBUTE46, PEB.ATTRIBUTE47, PEB.ATTRIBUTE48, PEB.ATTRIBUTE49, PEB.ATTRIBUTE50, PEB.ATTRIBUTE1_NUMBER, PEB.ATTRIBUTE2_NUMBER, PEB.ATTRIBUTE3_NUMBER, PEB.ATTRIBUTE4_NUMBER, PEB.ATTRIBUTE5_NUMBER, PEB.ATTRIBUTE6_NUMBER, PEB.ATTRIBUTE7_NUMBER, PEB.ATTRIBUTE8_NUMBER, PEB.ATTRIBUTE9_NUMBER, PEB.ATTRIBUTE10_NUMBER, PEB.ATTRIBUTE11_NUMBER, PEB.ATTRIBUTE12_NUMBER, PEB.ATTRIBUTE13_NUMBER, PEB.ATTRIBUTE14_NUMBER, PEB.ATTRIBUTE15_NUMBER, PEB.ATTRIBUTE1_DATE, PEB.ATTRIBUTE2_DATE, PEB.ATTRIBUTE3_DATE, PEB.ATTRIBUTE4_DATE, PEB.ATTRIBUTE5_DATE, PEB.ATTRIBUTE6_DATE, PEB.ATTRIBUTE7_DATE, PEB.ATTRIBUTE8_DATE, PEB.ATTRIBUTE9_DATE, PEB.ATTRIBUTE10_DATE, PEB.ATTRIBUTE11_DATE, PEB.ATTRIBUTE12_DATE, PEB.ATTRIBUTE13_DATE, PEB.ATTRIBUTE14_DATE, PEB.ATTRIBUTE15_DATE, PEB.PARENT_STRUCTURE_ID, PEB.OBJECT_VERSION_NUMBER, PEB.STRUCTURE_TYPE, PEB.LEAF_NODE_FLAG, PEB.CREATED_FROM_SOURCE_ID, PEB.PLANNING_START_DATE, PEB.PLANNING_END_DATE, PEB.BASELINE_START_DATE, PEB.BASELINE_FINISH_DATE, PEB.PERCENT_COMP_CALC_METHOD, PEB.ETC_CALC_METHOD, PEB.SITE_USE_ID, PEB.PLANNING_DATES_ROLLUP_FLAG, PEB.CAPITALIZABLE_FLAG, 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.DENORM_ELEM_VER_ID, PEB.PROJ_ELEMENT_ID, PEB.CRITICAL_FLAG, PEB.MILESTONE_FLAG, PEB.OVR_COST_IND_RATE_SCH_ID, PEB.TASK_TYPE_CODE, PEB.PRIMARY_RESOURCE_ID, PEB.TASK_CODE01_ID, PEB.TASK_CODE02_ID, PEB.TASK_CODE03_ID, PEB.TASK_CODE04_ID, PEB.TASK_CODE05_ID, PEB.TASK_CODE06_ID, PEB.TASK_CODE07_ID, PEB.TASK_CODE08_ID, PEB.TASK_CODE09_ID, PEB.TASK_CODE10_ID, PEB.TASK_CODE11_ID, PEB.TASK_CODE12_ID, PEB.TASK_CODE13_ID, PEB.TASK_CODE14_ID, PEB.TASK_CODE15_ID, PEB.TASK_CODE16_ID, PEB.TASK_CODE17_ID, PEB.TASK_CODE18_ID, PEB.TASK_CODE19_ID, PEB.TASK_CODE20_ID, PEB.TASK_CODE21_ID, PEB.TASK_CODE22_ID, PEB.TASK_CODE23_ID, PEB.TASK_CODE24_ID, PEB.TASK_CODE25_ID, PEB.TASK_CODE26_ID, PEB.TASK_CODE27_ID, PEB.TASK_CODE28_ID, PEB.TASK_CODE29_ID, PEB.TASK_CODE30_ID, PEB.TASK_CODE31_ID, PEB.TASK_CODE32_ID, PEB.TASK_CODE33_ID, PEB.TASK_CODE34_ID, PEB.TASK_CODE35_ID, PEB.TASK_CODE36_ID, PEB.TASK_CODE37_ID, PEB.TASK_CODE38_ID, PEB.TASK_CODE39_ID, PEB.TASK_CODE40_ID, PEB.NUMBER_ATTR01, PEB.NUMBER_ATTR02, PEB.NUMBER_ATTR03, PEB.NUMBER_ATTR04, PEB.NUMBER_ATTR05, PEB.NUMBER_ATTR06, PEB.NUMBER_ATTR07, PEB.NUMBER_ATTR08, PEB.NUMBER_ATTR09, PEB.NUMBER_ATTR10, PEB.TEXT_ATTR01, PEB.TEXT_ATTR02, PEB.TEXT_ATTR03, PEB.TEXT_ATTR04, PEB.TEXT_ATTR05, PEB.TEXT_ATTR06, PEB.TEXT_ATTR07, PEB.TEXT_ATTR08, PEB.TEXT_ATTR09, PEB.TEXT_ATTR10, PEB.TEXT_ATTR11, PEB.TEXT_ATTR12, PEB.TEXT_ATTR13, PEB.TEXT_ATTR14, PEB.TEXT_ATTR15, PEB.TEXT_ATTR16, PEB.TEXT_ATTR17, PEB.TEXT_ATTR18, PEB.TEXT_ATTR19, PEB.TEXT_ATTR20, PEB.ISSUE_ID, PEB.OBJECT_ASSOCIATION_BITMAP, PEB.TASK_STATUS_CODE, PEB.RQMT_ID, PEB.SPRINT_ID, PEB.EXTERNAL_ID, PEB.LAST_VIEWED_DATE, PEB.DENORM_EXECUTION_DISP_SEQ, PEB.ELEMENT_TYPE, PEB.USER_DEFINED_TASK_TYPE, PEB.IS_INTEGRATED, PEB.LAST_SYNC_DATE, PEB.GATE_FLAG, PEB.CTRL_MS_DATES_FLAG, PEB.CONTRACT_EVENT_ID FROM PJF_PROJ_ELEMENTS_B PEB, PJF_PROJ_ELEMENTS_TL PETL WHERE PEB.PROJ_ELEMENT_ID = PETL.PROJ_ELEMENT_ID AND PEB.PROJECT_ID = PETL.PROJECT_ID AND LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

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,

PETL.NAME,

PETL.DESCRIPTION,

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.ATTRIBUTE16,

PEB.ATTRIBUTE17,

PEB.ATTRIBUTE18,

PEB.ATTRIBUTE19,

PEB.ATTRIBUTE20,

PEB.ATTRIBUTE21,

PEB.ATTRIBUTE22,

PEB.ATTRIBUTE23,

PEB.ATTRIBUTE24,

PEB.ATTRIBUTE25,

PEB.ATTRIBUTE26,

PEB.ATTRIBUTE27,

PEB.ATTRIBUTE28,

PEB.ATTRIBUTE29,

PEB.ATTRIBUTE30,

PEB.ATTRIBUTE31,

PEB.ATTRIBUTE32,

PEB.ATTRIBUTE33,

PEB.ATTRIBUTE34,

PEB.ATTRIBUTE35,

PEB.ATTRIBUTE36,

PEB.ATTRIBUTE37,

PEB.ATTRIBUTE38,

PEB.ATTRIBUTE39,

PEB.ATTRIBUTE40,

PEB.ATTRIBUTE41,

PEB.ATTRIBUTE42,

PEB.ATTRIBUTE43,

PEB.ATTRIBUTE44,

PEB.ATTRIBUTE45,

PEB.ATTRIBUTE46,

PEB.ATTRIBUTE47,

PEB.ATTRIBUTE48,

PEB.ATTRIBUTE49,

PEB.ATTRIBUTE50,

PEB.ATTRIBUTE1_NUMBER,

PEB.ATTRIBUTE2_NUMBER,

PEB.ATTRIBUTE3_NUMBER,

PEB.ATTRIBUTE4_NUMBER,

PEB.ATTRIBUTE5_NUMBER,

PEB.ATTRIBUTE6_NUMBER,

PEB.ATTRIBUTE7_NUMBER,

PEB.ATTRIBUTE8_NUMBER,

PEB.ATTRIBUTE9_NUMBER,

PEB.ATTRIBUTE10_NUMBER,

PEB.ATTRIBUTE11_NUMBER,

PEB.ATTRIBUTE12_NUMBER,

PEB.ATTRIBUTE13_NUMBER,

PEB.ATTRIBUTE14_NUMBER,

PEB.ATTRIBUTE15_NUMBER,

PEB.ATTRIBUTE1_DATE,

PEB.ATTRIBUTE2_DATE,

PEB.ATTRIBUTE3_DATE,

PEB.ATTRIBUTE4_DATE,

PEB.ATTRIBUTE5_DATE,

PEB.ATTRIBUTE6_DATE,

PEB.ATTRIBUTE7_DATE,

PEB.ATTRIBUTE8_DATE,

PEB.ATTRIBUTE9_DATE,

PEB.ATTRIBUTE10_DATE,

PEB.ATTRIBUTE11_DATE,

PEB.ATTRIBUTE12_DATE,

PEB.ATTRIBUTE13_DATE,

PEB.ATTRIBUTE14_DATE,

PEB.ATTRIBUTE15_DATE,

PEB.PARENT_STRUCTURE_ID,

PEB.OBJECT_VERSION_NUMBER,

PEB.STRUCTURE_TYPE,

PEB.LEAF_NODE_FLAG,

PEB.CREATED_FROM_SOURCE_ID,

PEB.PLANNING_START_DATE,

PEB.PLANNING_END_DATE,

PEB.BASELINE_START_DATE,

PEB.BASELINE_FINISH_DATE,

PEB.PERCENT_COMP_CALC_METHOD,

PEB.ETC_CALC_METHOD,

PEB.SITE_USE_ID,

PEB.PLANNING_DATES_ROLLUP_FLAG,

PEB.CAPITALIZABLE_FLAG,

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.DENORM_ELEM_VER_ID,

PEB.PROJ_ELEMENT_ID,

PEB.CRITICAL_FLAG,

PEB.MILESTONE_FLAG,

PEB.OVR_COST_IND_RATE_SCH_ID,

PEB.TASK_TYPE_CODE,

PEB.PRIMARY_RESOURCE_ID,

PEB.TASK_CODE01_ID,

PEB.TASK_CODE02_ID,

PEB.TASK_CODE03_ID,

PEB.TASK_CODE04_ID,

PEB.TASK_CODE05_ID,

PEB.TASK_CODE06_ID,

PEB.TASK_CODE07_ID,

PEB.TASK_CODE08_ID,

PEB.TASK_CODE09_ID,

PEB.TASK_CODE10_ID,

PEB.TASK_CODE11_ID,

PEB.TASK_CODE12_ID,

PEB.TASK_CODE13_ID,

PEB.TASK_CODE14_ID,

PEB.TASK_CODE15_ID,

PEB.TASK_CODE16_ID,

PEB.TASK_CODE17_ID,

PEB.TASK_CODE18_ID,

PEB.TASK_CODE19_ID,

PEB.TASK_CODE20_ID,

PEB.TASK_CODE21_ID,

PEB.TASK_CODE22_ID,

PEB.TASK_CODE23_ID,

PEB.TASK_CODE24_ID,

PEB.TASK_CODE25_ID,

PEB.TASK_CODE26_ID,

PEB.TASK_CODE27_ID,

PEB.TASK_CODE28_ID,

PEB.TASK_CODE29_ID,

PEB.TASK_CODE30_ID,

PEB.TASK_CODE31_ID,

PEB.TASK_CODE32_ID,

PEB.TASK_CODE33_ID,

PEB.TASK_CODE34_ID,

PEB.TASK_CODE35_ID,

PEB.TASK_CODE36_ID,

PEB.TASK_CODE37_ID,

PEB.TASK_CODE38_ID,

PEB.TASK_CODE39_ID,

PEB.TASK_CODE40_ID,

PEB.NUMBER_ATTR01,

PEB.NUMBER_ATTR02,

PEB.NUMBER_ATTR03,

PEB.NUMBER_ATTR04,

PEB.NUMBER_ATTR05,

PEB.NUMBER_ATTR06,

PEB.NUMBER_ATTR07,

PEB.NUMBER_ATTR08,

PEB.NUMBER_ATTR09,

PEB.NUMBER_ATTR10,

PEB.TEXT_ATTR01,

PEB.TEXT_ATTR02,

PEB.TEXT_ATTR03,

PEB.TEXT_ATTR04,

PEB.TEXT_ATTR05,

PEB.TEXT_ATTR06,

PEB.TEXT_ATTR07,

PEB.TEXT_ATTR08,

PEB.TEXT_ATTR09,

PEB.TEXT_ATTR10,

PEB.TEXT_ATTR11,

PEB.TEXT_ATTR12,

PEB.TEXT_ATTR13,

PEB.TEXT_ATTR14,

PEB.TEXT_ATTR15,

PEB.TEXT_ATTR16,

PEB.TEXT_ATTR17,

PEB.TEXT_ATTR18,

PEB.TEXT_ATTR19,

PEB.TEXT_ATTR20,

PEB.ISSUE_ID,

PEB.OBJECT_ASSOCIATION_BITMAP,

PEB.TASK_STATUS_CODE,

PEB.RQMT_ID,

PEB.SPRINT_ID,

PEB.EXTERNAL_ID,

PEB.LAST_VIEWED_DATE,

PEB.DENORM_EXECUTION_DISP_SEQ,

PEB.ELEMENT_TYPE,

PEB.USER_DEFINED_TASK_TYPE,

PEB.IS_INTEGRATED,

PEB.LAST_SYNC_DATE,

PEB.GATE_FLAG,

PEB.CTRL_MS_DATES_FLAG,

PEB.CONTRACT_EVENT_ID

FROM

PJF_PROJ_ELEMENTS_B PEB,

PJF_PROJ_ELEMENTS_TL PETL

WHERE

PEB.PROJ_ELEMENT_ID = PETL.PROJ_ELEMENT_ID AND PEB.PROJECT_ID = PETL.PROJECT_ID AND LANGUAGE = USERENV('LANG')