PJF_PROJECTS_ALL_B

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
PROJECT_ID OBJECT_VERSION_NUMBER SEGMENT1 PROJECT_TYPE_ID CARRYING_OUT_ORGANIZATION_ID PUBLIC_SECTOR_FLAG PROJECT_STATUS_CODE START_DATE COMPLETION_DATE CLOSED_DATE CLIN_LINKED_CODE IC_CLIN_LINKED_CODE LIMIT_TO_TXN_CONTROLS_FLAG REQUEST_ID PROGRAM_ID PROGRAM_APPLICATION_ID PROGRAM_UPDATE_DATE SUMMARY_FLAG ENABLED_FLAG SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 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 COST_IND_RATE_SCH_ID COST_IND_SCH_FIXED_DATE OVR_COST_IND_RATE_SCH_ID TEMPLATE_FLAG VERIFICATION_DATE CREATED_FROM_PROJECT_ID TEMPLATE_START_DATE_ACTIVE TEMPLATE_END_DATE_ACTIVE ORG_ID PROJECT_UNIT_ID PM_PRODUCT_CODE PM_PROJECT_REFERENCE ACTUAL_START_DATE ACTUAL_FINISH_DATE EARLY_START_DATE EARLY_FINISH_DATE LATE_START_DATE LATE_FINISH_DATE SCHEDULED_START_DATE SCHEDULED_FINISH_DATE PROJECT_CURRENCY_CODE 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 WORK_TYPE_ID PROJECT_VALUE EXPECTED_APPROVAL_DATE PROJFUNC_CURRENCY_CODE CURRENCY_CONV_RATE_TYPE CURRENCY_CONV_DATE_TYPE_CODE CURRENCY_CONV_DATE PRIORITY_CODE TARGET_START_DATE TARGET_FINISH_DATE BASELINE_START_DATE BASELINE_FINISH_DATE SCHEDULED_AS_OF_DATE BASELINE_AS_OF_DATE ACTUAL_AS_OF_DATE SCHEDULED_DURATION BASELINE_DURATION ACTUAL_DURATION ASSET_ALLOCATION_METHOD CAPITAL_EVENT_PROCESSING CINT_RATE_SCH_ID CINT_ELIGIBLE_FLAG CINT_STOP_DATE STRUCTURE_SHARING_CODE KPI_NOTIFICATION_INCLUDE_NOTES KPI_NOTIFICATION_ENABLED KPI_NOTIFICATION_RECIPIENTS BPEL_STATUS_CODE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN GROUP_SPACE_TEMPLATE_NAME PROJECT_CALENDAR_ID PROJECT_CATEGORY HOURS_PER_DAY EXTERNAL_PROJECT_ID GROUP_SPACE_NAME

Name

PROJECT_ID

OBJECT_VERSION_NUMBER

SEGMENT1

PROJECT_TYPE_ID

CARRYING_OUT_ORGANIZATION_ID

PUBLIC_SECTOR_FLAG

PROJECT_STATUS_CODE

START_DATE

COMPLETION_DATE

CLOSED_DATE

CLIN_LINKED_CODE

IC_CLIN_LINKED_CODE

LIMIT_TO_TXN_CONTROLS_FLAG

REQUEST_ID

PROGRAM_ID

PROGRAM_APPLICATION_ID

PROGRAM_UPDATE_DATE

SUMMARY_FLAG

ENABLED_FLAG

SEGMENT2

SEGMENT3

SEGMENT4

SEGMENT5

SEGMENT6

SEGMENT7

SEGMENT8

SEGMENT9

SEGMENT10

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

COST_IND_RATE_SCH_ID

COST_IND_SCH_FIXED_DATE

OVR_COST_IND_RATE_SCH_ID

TEMPLATE_FLAG

VERIFICATION_DATE

CREATED_FROM_PROJECT_ID

TEMPLATE_START_DATE_ACTIVE

TEMPLATE_END_DATE_ACTIVE

ORG_ID

PROJECT_UNIT_ID

PM_PRODUCT_CODE

PM_PROJECT_REFERENCE

ACTUAL_START_DATE

ACTUAL_FINISH_DATE

EARLY_START_DATE

EARLY_FINISH_DATE

LATE_START_DATE

LATE_FINISH_DATE

SCHEDULED_START_DATE

SCHEDULED_FINISH_DATE

PROJECT_CURRENCY_CODE

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

WORK_TYPE_ID

PROJECT_VALUE

EXPECTED_APPROVAL_DATE

PROJFUNC_CURRENCY_CODE

CURRENCY_CONV_RATE_TYPE

CURRENCY_CONV_DATE_TYPE_CODE

CURRENCY_CONV_DATE

PRIORITY_CODE

TARGET_START_DATE

TARGET_FINISH_DATE

BASELINE_START_DATE

BASELINE_FINISH_DATE

SCHEDULED_AS_OF_DATE

BASELINE_AS_OF_DATE

ACTUAL_AS_OF_DATE

SCHEDULED_DURATION

BASELINE_DURATION

ACTUAL_DURATION

ASSET_ALLOCATION_METHOD

CAPITAL_EVENT_PROCESSING

CINT_RATE_SCH_ID

CINT_ELIGIBLE_FLAG

CINT_STOP_DATE

STRUCTURE_SHARING_CODE

KPI_NOTIFICATION_INCLUDE_NOTES

KPI_NOTIFICATION_ENABLED

KPI_NOTIFICATION_RECIPIENTS

BPEL_STATUS_CODE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

GROUP_SPACE_TEMPLATE_NAME

PROJECT_CALENDAR_ID

PROJECT_CATEGORY

HOURS_PER_DAY

EXTERNAL_PROJECT_ID

GROUP_SPACE_NAME

Query

SQL_Statement
SELECT PJF_PROJECTS_ALL_B.PROJECT_ID PROJECT_ID, PJF_PROJECTS_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJF_PROJECTS_ALL_B.SEGMENT1 SEGMENT1, PJF_PROJECTS_ALL_B.PROJECT_TYPE_ID PROJECT_TYPE_ID, PJF_PROJECTS_ALL_B.CARRYING_OUT_ORGANIZATION_ID CARRYING_OUT_ORGANIZATION_ID, PJF_PROJECTS_ALL_B.PUBLIC_SECTOR_FLAG PUBLIC_SECTOR_FLAG, PJF_PROJECTS_ALL_B.PROJECT_STATUS_CODE PROJECT_STATUS_CODE, PJF_PROJECTS_ALL_B.START_DATE START_DATE, PJF_PROJECTS_ALL_B.COMPLETION_DATE COMPLETION_DATE, PJF_PROJECTS_ALL_B.CLOSED_DATE CLOSED_DATE, PJF_PROJECTS_ALL_B.CLIN_LINKED_CODE CLIN_LINKED_CODE, PJF_PROJECTS_ALL_B.IC_CLIN_LINKED_CODE IC_CLIN_LINKED_CODE, PJF_PROJECTS_ALL_B.LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG, PJF_PROJECTS_ALL_B.REQUEST_ID REQUEST_ID, PJF_PROJECTS_ALL_B.PROGRAM_ID PROGRAM_ID, PJF_PROJECTS_ALL_B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PJF_PROJECTS_ALL_B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PJF_PROJECTS_ALL_B.SUMMARY_FLAG SUMMARY_FLAG, PJF_PROJECTS_ALL_B.ENABLED_FLAG ENABLED_FLAG, PJF_PROJECTS_ALL_B.SEGMENT2 SEGMENT2, PJF_PROJECTS_ALL_B.SEGMENT3 SEGMENT3, PJF_PROJECTS_ALL_B.SEGMENT4 SEGMENT4, PJF_PROJECTS_ALL_B.SEGMENT5 SEGMENT5, PJF_PROJECTS_ALL_B.SEGMENT6 SEGMENT6, PJF_PROJECTS_ALL_B.SEGMENT7 SEGMENT7, PJF_PROJECTS_ALL_B.SEGMENT8 SEGMENT8, PJF_PROJECTS_ALL_B.SEGMENT9 SEGMENT9, PJF_PROJECTS_ALL_B.SEGMENT10 SEGMENT10, PJF_PROJECTS_ALL_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PJF_PROJECTS_ALL_B.ATTRIBUTE1 ATTRIBUTE1, PJF_PROJECTS_ALL_B.ATTRIBUTE2 ATTRIBUTE2, PJF_PROJECTS_ALL_B.ATTRIBUTE3 ATTRIBUTE3, PJF_PROJECTS_ALL_B.ATTRIBUTE4 ATTRIBUTE4, PJF_PROJECTS_ALL_B.ATTRIBUTE5 ATTRIBUTE5, PJF_PROJECTS_ALL_B.ATTRIBUTE6 ATTRIBUTE6, PJF_PROJECTS_ALL_B.ATTRIBUTE7 ATTRIBUTE7, PJF_PROJECTS_ALL_B.ATTRIBUTE8 ATTRIBUTE8, PJF_PROJECTS_ALL_B.ATTRIBUTE9 ATTRIBUTE9, PJF_PROJECTS_ALL_B.ATTRIBUTE10 ATTRIBUTE10, PJF_PROJECTS_ALL_B.ATTRIBUTE11 ATTRIBUTE11, PJF_PROJECTS_ALL_B.ATTRIBUTE12 ATTRIBUTE12, PJF_PROJECTS_ALL_B.ATTRIBUTE13 ATTRIBUTE13, PJF_PROJECTS_ALL_B.ATTRIBUTE14 ATTRIBUTE14, PJF_PROJECTS_ALL_B.ATTRIBUTE15 ATTRIBUTE15, PJF_PROJECTS_ALL_B.ATTRIBUTE16 ATTRIBUTE16, PJF_PROJECTS_ALL_B.ATTRIBUTE17 ATTRIBUTE17, PJF_PROJECTS_ALL_B.ATTRIBUTE18 ATTRIBUTE18, PJF_PROJECTS_ALL_B.ATTRIBUTE19 ATTRIBUTE19, PJF_PROJECTS_ALL_B.ATTRIBUTE20 ATTRIBUTE20, PJF_PROJECTS_ALL_B.ATTRIBUTE21 ATTRIBUTE21, PJF_PROJECTS_ALL_B.ATTRIBUTE22 ATTRIBUTE22, PJF_PROJECTS_ALL_B.ATTRIBUTE23 ATTRIBUTE23, PJF_PROJECTS_ALL_B.ATTRIBUTE24 ATTRIBUTE24, PJF_PROJECTS_ALL_B.ATTRIBUTE25 ATTRIBUTE25, PJF_PROJECTS_ALL_B.ATTRIBUTE26 ATTRIBUTE26, PJF_PROJECTS_ALL_B.ATTRIBUTE27 ATTRIBUTE27, PJF_PROJECTS_ALL_B.ATTRIBUTE28 ATTRIBUTE28, PJF_PROJECTS_ALL_B.ATTRIBUTE29 ATTRIBUTE29, PJF_PROJECTS_ALL_B.ATTRIBUTE30 ATTRIBUTE30, PJF_PROJECTS_ALL_B.ATTRIBUTE31 ATTRIBUTE31, PJF_PROJECTS_ALL_B.ATTRIBUTE32 ATTRIBUTE32, PJF_PROJECTS_ALL_B.ATTRIBUTE33 ATTRIBUTE33, PJF_PROJECTS_ALL_B.ATTRIBUTE34 ATTRIBUTE34, PJF_PROJECTS_ALL_B.ATTRIBUTE35 ATTRIBUTE35, PJF_PROJECTS_ALL_B.ATTRIBUTE36 ATTRIBUTE36, PJF_PROJECTS_ALL_B.ATTRIBUTE37 ATTRIBUTE37, PJF_PROJECTS_ALL_B.ATTRIBUTE38 ATTRIBUTE38, PJF_PROJECTS_ALL_B.ATTRIBUTE39 ATTRIBUTE39, PJF_PROJECTS_ALL_B.ATTRIBUTE40 ATTRIBUTE40, PJF_PROJECTS_ALL_B.ATTRIBUTE41 ATTRIBUTE41, PJF_PROJECTS_ALL_B.ATTRIBUTE42 ATTRIBUTE42, PJF_PROJECTS_ALL_B.ATTRIBUTE43 ATTRIBUTE43, PJF_PROJECTS_ALL_B.ATTRIBUTE44 ATTRIBUTE44, PJF_PROJECTS_ALL_B.ATTRIBUTE45 ATTRIBUTE45, PJF_PROJECTS_ALL_B.ATTRIBUTE46 ATTRIBUTE46, PJF_PROJECTS_ALL_B.ATTRIBUTE47 ATTRIBUTE47, PJF_PROJECTS_ALL_B.ATTRIBUTE48 ATTRIBUTE48, PJF_PROJECTS_ALL_B.ATTRIBUTE49 ATTRIBUTE49, PJF_PROJECTS_ALL_B.ATTRIBUTE50 ATTRIBUTE50, PJF_PROJECTS_ALL_B.ATTRIBUTE1_NUMBER ATTRIBUTE1_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE2_NUMBER ATTRIBUTE2_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE3_NUMBER ATTRIBUTE3_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE4_NUMBER ATTRIBUTE4_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE5_NUMBER ATTRIBUTE5_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE6_NUMBER ATTRIBUTE6_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE7_NUMBER ATTRIBUTE7_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE8_NUMBER ATTRIBUTE8_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE9_NUMBER ATTRIBUTE9_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE10_NUMBER ATTRIBUTE10_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE11_NUMBER ATTRIBUTE11_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE12_NUMBER ATTRIBUTE12_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE13_NUMBER ATTRIBUTE13_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE14_NUMBER ATTRIBUTE14_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE15_NUMBER ATTRIBUTE15_NUMBER, PJF_PROJECTS_ALL_B.ATTRIBUTE1_DATE ATTRIBUTE1_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE2_DATE ATTRIBUTE2_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE3_DATE ATTRIBUTE3_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE4_DATE ATTRIBUTE4_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE5_DATE ATTRIBUTE5_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE6_DATE ATTRIBUTE6_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE7_DATE ATTRIBUTE7_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE8_DATE ATTRIBUTE8_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE9_DATE ATTRIBUTE9_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE10_DATE ATTRIBUTE10_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE11_DATE ATTRIBUTE11_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE12_DATE ATTRIBUTE12_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE13_DATE ATTRIBUTE13_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE14_DATE ATTRIBUTE14_DATE, PJF_PROJECTS_ALL_B.ATTRIBUTE15_DATE ATTRIBUTE15_DATE, PJF_PROJECTS_ALL_B.COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID, PJF_PROJECTS_ALL_B.COST_IND_SCH_FIXED_DATE COST_IND_SCH_FIXED_DATE, PJF_PROJECTS_ALL_B.OVR_COST_IND_RATE_SCH_ID OVR_COST_IND_RATE_SCH_ID, PJF_PROJECTS_ALL_B.TEMPLATE_FLAG TEMPLATE_FLAG, PJF_PROJECTS_ALL_B.VERIFICATION_DATE VERIFICATION_DATE, PJF_PROJECTS_ALL_B.CREATED_FROM_PROJECT_ID CREATED_FROM_PROJECT_ID, PJF_PROJECTS_ALL_B.TEMPLATE_START_DATE_ACTIVE TEMPLATE_START_DATE_ACTIVE, PJF_PROJECTS_ALL_B.TEMPLATE_END_DATE_ACTIVE TEMPLATE_END_DATE_ACTIVE, PJF_PROJECTS_ALL_B.ORG_ID ORG_ID, PJF_PROJECTS_ALL_B.PROJECT_UNIT_ID PROJECT_UNIT_ID, PJF_PROJECTS_ALL_B.PM_PRODUCT_CODE PM_PRODUCT_CODE, PJF_PROJECTS_ALL_B.PM_PROJECT_REFERENCE PM_PROJECT_REFERENCE, PJF_PROJECTS_ALL_B.ACTUAL_START_DATE ACTUAL_START_DATE, PJF_PROJECTS_ALL_B.ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE, PJF_PROJECTS_ALL_B.EARLY_START_DATE EARLY_START_DATE, PJF_PROJECTS_ALL_B.EARLY_FINISH_DATE EARLY_FINISH_DATE, PJF_PROJECTS_ALL_B.LATE_START_DATE LATE_START_DATE, PJF_PROJECTS_ALL_B.LATE_FINISH_DATE LATE_FINISH_DATE, PJF_PROJECTS_ALL_B.SCHEDULED_START_DATE SCHEDULED_START_DATE, PJF_PROJECTS_ALL_B.SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE, PJF_PROJECTS_ALL_B.PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PJF_PROJECTS_ALL_B.ALLOW_CROSS_CHARGE_FLAG ALLOW_CROSS_CHARGE_FLAG, PJF_PROJECTS_ALL_B.CC_PROCESS_LABOR_FLAG CC_PROCESS_LABOR_FLAG, PJF_PROJECTS_ALL_B.LABOR_TP_SCHEDULE_ID LABOR_TP_SCHEDULE_ID, PJF_PROJECTS_ALL_B.LABOR_TP_FIXED_DATE LABOR_TP_FIXED_DATE, PJF_PROJECTS_ALL_B.CC_PROCESS_NL_FLAG CC_PROCESS_NL_FLAG, PJF_PROJECTS_ALL_B.NL_TP_SCHEDULE_ID NL_TP_SCHEDULE_ID, PJF_PROJECTS_ALL_B.NL_TP_FIXED_DATE NL_TP_FIXED_DATE, PJF_PROJECTS_ALL_B.WORK_TYPE_ID WORK_TYPE_ID, PJF_PROJECTS_ALL_B.PROJECT_VALUE PROJECT_VALUE, PJF_PROJECTS_ALL_B.EXPECTED_APPROVAL_DATE EXPECTED_APPROVAL_DATE, PJF_PROJECTS_ALL_B.PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PJF_PROJECTS_ALL_B.CURRENCY_CONV_RATE_TYPE CURRENCY_CONV_RATE_TYPE, PJF_PROJECTS_ALL_B.CURRENCY_CONV_DATE_TYPE_CODE CURRENCY_CONV_DATE_TYPE_CODE, PJF_PROJECTS_ALL_B.CURRENCY_CONV_DATE CURRENCY_CONV_DATE, PJF_PROJECTS_ALL_B.PRIORITY_CODE PRIORITY_CODE, PJF_PROJECTS_ALL_B.TARGET_START_DATE TARGET_START_DATE, PJF_PROJECTS_ALL_B.TARGET_FINISH_DATE TARGET_FINISH_DATE, PJF_PROJECTS_ALL_B.BASELINE_START_DATE BASELINE_START_DATE, PJF_PROJECTS_ALL_B.BASELINE_FINISH_DATE BASELINE_FINISH_DATE, PJF_PROJECTS_ALL_B.SCHEDULED_AS_OF_DATE SCHEDULED_AS_OF_DATE, PJF_PROJECTS_ALL_B.BASELINE_AS_OF_DATE BASELINE_AS_OF_DATE, PJF_PROJECTS_ALL_B.ACTUAL_AS_OF_DATE ACTUAL_AS_OF_DATE, PJF_PROJECTS_ALL_B.SCHEDULED_DURATION SCHEDULED_DURATION, PJF_PROJECTS_ALL_B.BASELINE_DURATION BASELINE_DURATION, PJF_PROJECTS_ALL_B.ACTUAL_DURATION ACTUAL_DURATION, PJF_PROJECTS_ALL_B.ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD, PJF_PROJECTS_ALL_B.CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING, PJF_PROJECTS_ALL_B.CINT_RATE_SCH_ID CINT_RATE_SCH_ID, PJF_PROJECTS_ALL_B.CINT_ELIGIBLE_FLAG CINT_ELIGIBLE_FLAG, PJF_PROJECTS_ALL_B.CINT_STOP_DATE CINT_STOP_DATE, PJF_PROJECTS_ALL_B.STRUCTURE_SHARING_CODE STRUCTURE_SHARING_CODE, PJF_PROJECTS_ALL_B.KPI_NOTIFICATION_INCLUDE_NOTES, PJF_PROJECTS_ALL_B.KPI_NOTIFICATION_ENABLED, PJF_PROJECTS_ALL_B.KPI_NOTIFICATION_RECIPIENTS, PJF_PROJECTS_ALL_B.BPEL_STATUS_CODE, PJF_PROJECTS_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJF_PROJECTS_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJF_PROJECTS_ALL_B.CREATION_DATE CREATION_DATE, PJF_PROJECTS_ALL_B.CREATED_BY CREATED_BY, PJF_PROJECTS_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJF_PROJECTS_ALL_B.GROUP_SPACE_TEMPLATE_NAME GROUP_SPACE_TEMPLATE_NAME, PJF_PROJECTS_ALL_B.PROJECT_CALENDAR_ID, PJF_PROJECTS_ALL_B.PROJECT_CATEGORY, PJF_PROJECTS_ALL_B.HOURS_PER_DAY, PJF_PROJECTS_ALL_B.EXTERNAL_PROJECT_ID, PJF_PROJECTS_ALL_B.GROUP_SPACE_NAME GROUP_SPACE_NAME FROM PJF_PROJECTS_ALL_B

SQL_Statement

SELECT

PJF_PROJECTS_ALL_B.PROJECT_ID PROJECT_ID,

PJF_PROJECTS_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJF_PROJECTS_ALL_B.SEGMENT1 SEGMENT1,

PJF_PROJECTS_ALL_B.PROJECT_TYPE_ID PROJECT_TYPE_ID,

PJF_PROJECTS_ALL_B.CARRYING_OUT_ORGANIZATION_ID CARRYING_OUT_ORGANIZATION_ID,

PJF_PROJECTS_ALL_B.PUBLIC_SECTOR_FLAG PUBLIC_SECTOR_FLAG,

PJF_PROJECTS_ALL_B.PROJECT_STATUS_CODE PROJECT_STATUS_CODE,

PJF_PROJECTS_ALL_B.START_DATE START_DATE,

PJF_PROJECTS_ALL_B.COMPLETION_DATE COMPLETION_DATE,

PJF_PROJECTS_ALL_B.CLOSED_DATE CLOSED_DATE,

PJF_PROJECTS_ALL_B.CLIN_LINKED_CODE CLIN_LINKED_CODE,

PJF_PROJECTS_ALL_B.IC_CLIN_LINKED_CODE IC_CLIN_LINKED_CODE,

PJF_PROJECTS_ALL_B.LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG,

PJF_PROJECTS_ALL_B.REQUEST_ID REQUEST_ID,

PJF_PROJECTS_ALL_B.PROGRAM_ID PROGRAM_ID,

PJF_PROJECTS_ALL_B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID,

PJF_PROJECTS_ALL_B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE,

PJF_PROJECTS_ALL_B.SUMMARY_FLAG SUMMARY_FLAG,

PJF_PROJECTS_ALL_B.ENABLED_FLAG ENABLED_FLAG,

PJF_PROJECTS_ALL_B.SEGMENT2 SEGMENT2,

PJF_PROJECTS_ALL_B.SEGMENT3 SEGMENT3,

PJF_PROJECTS_ALL_B.SEGMENT4 SEGMENT4,

PJF_PROJECTS_ALL_B.SEGMENT5 SEGMENT5,

PJF_PROJECTS_ALL_B.SEGMENT6 SEGMENT6,

PJF_PROJECTS_ALL_B.SEGMENT7 SEGMENT7,

PJF_PROJECTS_ALL_B.SEGMENT8 SEGMENT8,

PJF_PROJECTS_ALL_B.SEGMENT9 SEGMENT9,

PJF_PROJECTS_ALL_B.SEGMENT10 SEGMENT10,

PJF_PROJECTS_ALL_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PJF_PROJECTS_ALL_B.ATTRIBUTE1 ATTRIBUTE1,

PJF_PROJECTS_ALL_B.ATTRIBUTE2 ATTRIBUTE2,

PJF_PROJECTS_ALL_B.ATTRIBUTE3 ATTRIBUTE3,

PJF_PROJECTS_ALL_B.ATTRIBUTE4 ATTRIBUTE4,

PJF_PROJECTS_ALL_B.ATTRIBUTE5 ATTRIBUTE5,

PJF_PROJECTS_ALL_B.ATTRIBUTE6 ATTRIBUTE6,

PJF_PROJECTS_ALL_B.ATTRIBUTE7 ATTRIBUTE7,

PJF_PROJECTS_ALL_B.ATTRIBUTE8 ATTRIBUTE8,

PJF_PROJECTS_ALL_B.ATTRIBUTE9 ATTRIBUTE9,

PJF_PROJECTS_ALL_B.ATTRIBUTE10 ATTRIBUTE10,

PJF_PROJECTS_ALL_B.ATTRIBUTE11 ATTRIBUTE11,

PJF_PROJECTS_ALL_B.ATTRIBUTE12 ATTRIBUTE12,

PJF_PROJECTS_ALL_B.ATTRIBUTE13 ATTRIBUTE13,

PJF_PROJECTS_ALL_B.ATTRIBUTE14 ATTRIBUTE14,

PJF_PROJECTS_ALL_B.ATTRIBUTE15 ATTRIBUTE15,

PJF_PROJECTS_ALL_B.ATTRIBUTE16 ATTRIBUTE16,

PJF_PROJECTS_ALL_B.ATTRIBUTE17 ATTRIBUTE17,

PJF_PROJECTS_ALL_B.ATTRIBUTE18 ATTRIBUTE18,

PJF_PROJECTS_ALL_B.ATTRIBUTE19 ATTRIBUTE19,

PJF_PROJECTS_ALL_B.ATTRIBUTE20 ATTRIBUTE20,

PJF_PROJECTS_ALL_B.ATTRIBUTE21 ATTRIBUTE21,

PJF_PROJECTS_ALL_B.ATTRIBUTE22 ATTRIBUTE22,

PJF_PROJECTS_ALL_B.ATTRIBUTE23 ATTRIBUTE23,

PJF_PROJECTS_ALL_B.ATTRIBUTE24 ATTRIBUTE24,

PJF_PROJECTS_ALL_B.ATTRIBUTE25 ATTRIBUTE25,

PJF_PROJECTS_ALL_B.ATTRIBUTE26 ATTRIBUTE26,

PJF_PROJECTS_ALL_B.ATTRIBUTE27 ATTRIBUTE27,

PJF_PROJECTS_ALL_B.ATTRIBUTE28 ATTRIBUTE28,

PJF_PROJECTS_ALL_B.ATTRIBUTE29 ATTRIBUTE29,

PJF_PROJECTS_ALL_B.ATTRIBUTE30 ATTRIBUTE30,

PJF_PROJECTS_ALL_B.ATTRIBUTE31 ATTRIBUTE31,

PJF_PROJECTS_ALL_B.ATTRIBUTE32 ATTRIBUTE32,

PJF_PROJECTS_ALL_B.ATTRIBUTE33 ATTRIBUTE33,

PJF_PROJECTS_ALL_B.ATTRIBUTE34 ATTRIBUTE34,

PJF_PROJECTS_ALL_B.ATTRIBUTE35 ATTRIBUTE35,

PJF_PROJECTS_ALL_B.ATTRIBUTE36 ATTRIBUTE36,

PJF_PROJECTS_ALL_B.ATTRIBUTE37 ATTRIBUTE37,

PJF_PROJECTS_ALL_B.ATTRIBUTE38 ATTRIBUTE38,

PJF_PROJECTS_ALL_B.ATTRIBUTE39 ATTRIBUTE39,

PJF_PROJECTS_ALL_B.ATTRIBUTE40 ATTRIBUTE40,

PJF_PROJECTS_ALL_B.ATTRIBUTE41 ATTRIBUTE41,

PJF_PROJECTS_ALL_B.ATTRIBUTE42 ATTRIBUTE42,

PJF_PROJECTS_ALL_B.ATTRIBUTE43 ATTRIBUTE43,

PJF_PROJECTS_ALL_B.ATTRIBUTE44 ATTRIBUTE44,

PJF_PROJECTS_ALL_B.ATTRIBUTE45 ATTRIBUTE45,

PJF_PROJECTS_ALL_B.ATTRIBUTE46 ATTRIBUTE46,

PJF_PROJECTS_ALL_B.ATTRIBUTE47 ATTRIBUTE47,

PJF_PROJECTS_ALL_B.ATTRIBUTE48 ATTRIBUTE48,

PJF_PROJECTS_ALL_B.ATTRIBUTE49 ATTRIBUTE49,

PJF_PROJECTS_ALL_B.ATTRIBUTE50 ATTRIBUTE50,

PJF_PROJECTS_ALL_B.ATTRIBUTE1_NUMBER ATTRIBUTE1_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE2_NUMBER ATTRIBUTE2_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE3_NUMBER ATTRIBUTE3_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE4_NUMBER ATTRIBUTE4_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE5_NUMBER ATTRIBUTE5_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE6_NUMBER ATTRIBUTE6_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE7_NUMBER ATTRIBUTE7_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE8_NUMBER ATTRIBUTE8_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE9_NUMBER ATTRIBUTE9_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE10_NUMBER ATTRIBUTE10_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE11_NUMBER ATTRIBUTE11_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE12_NUMBER ATTRIBUTE12_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE13_NUMBER ATTRIBUTE13_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE14_NUMBER ATTRIBUTE14_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE15_NUMBER ATTRIBUTE15_NUMBER,

PJF_PROJECTS_ALL_B.ATTRIBUTE1_DATE ATTRIBUTE1_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE2_DATE ATTRIBUTE2_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE3_DATE ATTRIBUTE3_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE4_DATE ATTRIBUTE4_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE5_DATE ATTRIBUTE5_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE6_DATE ATTRIBUTE6_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE7_DATE ATTRIBUTE7_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE8_DATE ATTRIBUTE8_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE9_DATE ATTRIBUTE9_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE10_DATE ATTRIBUTE10_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE11_DATE ATTRIBUTE11_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE12_DATE ATTRIBUTE12_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE13_DATE ATTRIBUTE13_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE14_DATE ATTRIBUTE14_DATE,

PJF_PROJECTS_ALL_B.ATTRIBUTE15_DATE ATTRIBUTE15_DATE,

PJF_PROJECTS_ALL_B.COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID,

PJF_PROJECTS_ALL_B.COST_IND_SCH_FIXED_DATE COST_IND_SCH_FIXED_DATE,

PJF_PROJECTS_ALL_B.OVR_COST_IND_RATE_SCH_ID OVR_COST_IND_RATE_SCH_ID,

PJF_PROJECTS_ALL_B.TEMPLATE_FLAG TEMPLATE_FLAG,

PJF_PROJECTS_ALL_B.VERIFICATION_DATE VERIFICATION_DATE,

PJF_PROJECTS_ALL_B.CREATED_FROM_PROJECT_ID CREATED_FROM_PROJECT_ID,

PJF_PROJECTS_ALL_B.TEMPLATE_START_DATE_ACTIVE TEMPLATE_START_DATE_ACTIVE,

PJF_PROJECTS_ALL_B.TEMPLATE_END_DATE_ACTIVE TEMPLATE_END_DATE_ACTIVE,

PJF_PROJECTS_ALL_B.ORG_ID ORG_ID,

PJF_PROJECTS_ALL_B.PROJECT_UNIT_ID PROJECT_UNIT_ID,

PJF_PROJECTS_ALL_B.PM_PRODUCT_CODE PM_PRODUCT_CODE,

PJF_PROJECTS_ALL_B.PM_PROJECT_REFERENCE PM_PROJECT_REFERENCE,

PJF_PROJECTS_ALL_B.ACTUAL_START_DATE ACTUAL_START_DATE,

PJF_PROJECTS_ALL_B.ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE,

PJF_PROJECTS_ALL_B.EARLY_START_DATE EARLY_START_DATE,

PJF_PROJECTS_ALL_B.EARLY_FINISH_DATE EARLY_FINISH_DATE,

PJF_PROJECTS_ALL_B.LATE_START_DATE LATE_START_DATE,

PJF_PROJECTS_ALL_B.LATE_FINISH_DATE LATE_FINISH_DATE,

PJF_PROJECTS_ALL_B.SCHEDULED_START_DATE SCHEDULED_START_DATE,

PJF_PROJECTS_ALL_B.SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE,

PJF_PROJECTS_ALL_B.PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE,

PJF_PROJECTS_ALL_B.ALLOW_CROSS_CHARGE_FLAG ALLOW_CROSS_CHARGE_FLAG,

PJF_PROJECTS_ALL_B.CC_PROCESS_LABOR_FLAG CC_PROCESS_LABOR_FLAG,

PJF_PROJECTS_ALL_B.LABOR_TP_SCHEDULE_ID LABOR_TP_SCHEDULE_ID,

PJF_PROJECTS_ALL_B.LABOR_TP_FIXED_DATE LABOR_TP_FIXED_DATE,

PJF_PROJECTS_ALL_B.CC_PROCESS_NL_FLAG CC_PROCESS_NL_FLAG,

PJF_PROJECTS_ALL_B.NL_TP_SCHEDULE_ID NL_TP_SCHEDULE_ID,

PJF_PROJECTS_ALL_B.NL_TP_FIXED_DATE NL_TP_FIXED_DATE,

PJF_PROJECTS_ALL_B.WORK_TYPE_ID WORK_TYPE_ID,

PJF_PROJECTS_ALL_B.PROJECT_VALUE PROJECT_VALUE,

PJF_PROJECTS_ALL_B.EXPECTED_APPROVAL_DATE EXPECTED_APPROVAL_DATE,

PJF_PROJECTS_ALL_B.PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE,

PJF_PROJECTS_ALL_B.CURRENCY_CONV_RATE_TYPE CURRENCY_CONV_RATE_TYPE,

PJF_PROJECTS_ALL_B.CURRENCY_CONV_DATE_TYPE_CODE CURRENCY_CONV_DATE_TYPE_CODE,

PJF_PROJECTS_ALL_B.CURRENCY_CONV_DATE CURRENCY_CONV_DATE,

PJF_PROJECTS_ALL_B.PRIORITY_CODE PRIORITY_CODE,

PJF_PROJECTS_ALL_B.TARGET_START_DATE TARGET_START_DATE,

PJF_PROJECTS_ALL_B.TARGET_FINISH_DATE TARGET_FINISH_DATE,

PJF_PROJECTS_ALL_B.BASELINE_START_DATE BASELINE_START_DATE,

PJF_PROJECTS_ALL_B.BASELINE_FINISH_DATE BASELINE_FINISH_DATE,

PJF_PROJECTS_ALL_B.SCHEDULED_AS_OF_DATE SCHEDULED_AS_OF_DATE,

PJF_PROJECTS_ALL_B.BASELINE_AS_OF_DATE BASELINE_AS_OF_DATE,

PJF_PROJECTS_ALL_B.ACTUAL_AS_OF_DATE ACTUAL_AS_OF_DATE,

PJF_PROJECTS_ALL_B.SCHEDULED_DURATION SCHEDULED_DURATION,

PJF_PROJECTS_ALL_B.BASELINE_DURATION BASELINE_DURATION,

PJF_PROJECTS_ALL_B.ACTUAL_DURATION ACTUAL_DURATION,

PJF_PROJECTS_ALL_B.ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD,

PJF_PROJECTS_ALL_B.CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING,

PJF_PROJECTS_ALL_B.CINT_RATE_SCH_ID CINT_RATE_SCH_ID,

PJF_PROJECTS_ALL_B.CINT_ELIGIBLE_FLAG CINT_ELIGIBLE_FLAG,

PJF_PROJECTS_ALL_B.CINT_STOP_DATE CINT_STOP_DATE,

PJF_PROJECTS_ALL_B.STRUCTURE_SHARING_CODE STRUCTURE_SHARING_CODE,

PJF_PROJECTS_ALL_B.KPI_NOTIFICATION_INCLUDE_NOTES,

PJF_PROJECTS_ALL_B.KPI_NOTIFICATION_ENABLED,

PJF_PROJECTS_ALL_B.KPI_NOTIFICATION_RECIPIENTS,

PJF_PROJECTS_ALL_B.BPEL_STATUS_CODE,

PJF_PROJECTS_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJF_PROJECTS_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJF_PROJECTS_ALL_B.CREATION_DATE CREATION_DATE,

PJF_PROJECTS_ALL_B.CREATED_BY CREATED_BY,

PJF_PROJECTS_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJF_PROJECTS_ALL_B.GROUP_SPACE_TEMPLATE_NAME GROUP_SPACE_TEMPLATE_NAME,

PJF_PROJECTS_ALL_B.PROJECT_CALENDAR_ID,

PJF_PROJECTS_ALL_B.PROJECT_CATEGORY,

PJF_PROJECTS_ALL_B.HOURS_PER_DAY,

PJF_PROJECTS_ALL_B.EXTERNAL_PROJECT_ID,

PJF_PROJECTS_ALL_B.GROUP_SPACE_NAME GROUP_SPACE_NAME

FROM

PJF_PROJECTS_ALL_B