PJF_PROJECTS_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 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

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

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

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

FROM

PJF_PROJECTS_ALL_B