VIEW: PA.PA_PROJECTS_ALL#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, NAME NAME, SEGMENT1 SEGMENT1, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROJECT_TYPE PROJECT_TYPE, CARRYING_OUT_ORGANIZATION_ID CARRYING_OUT_ORGANIZATION_ID, PUBLIC_SECTOR_FLAG PUBLIC_SECTOR_FLAG, PROJECT_STATUS_CODE PROJECT_STATUS_CODE, DESCRIPTION DESCRIPTION, START_DATE START_DATE, COMPLETION_DATE COMPLETION_DATE, CLOSED_DATE CLOSED_DATE, DISTRIBUTION_RULE DISTRIBUTION_RULE, LABOR_INVOICE_FORMAT_ID LABOR_INVOICE_FORMAT_ID, NON_LABOR_INVOICE_FORMAT_ID NON_LABOR_INVOICE_FORMAT_ID, RETENTION_INVOICE_FORMAT_ID RETENTION_INVOICE_FORMAT_ID, RETENTION_PERCENTAGE RETENTION_PERCENTAGE, BILLING_OFFSET BILLING_OFFSET, BILLING_CYCLE BILLING_CYCLE, LABOR_STD_BILL_RATE_SCHDL LABOR_STD_BILL_RATE_SCHDL, LABOR_BILL_RATE_ORG_ID LABOR_BILL_RATE_ORG_ID, LABOR_SCHEDULE_FIXED_DATE LABOR_SCHEDULE_FIXED_DATE, LABOR_SCHEDULE_DISCOUNT LABOR_SCHEDULE_DISCOUNT, NON_LABOR_STD_BILL_RATE_SCHDL NON_LABOR_STD_BILL_RATE_SCHDL, NON_LABOR_BILL_RATE_ORG_ID NON_LABOR_BILL_RATE_ORG_ID, NON_LABOR_SCHEDULE_FIXED_DATE NON_LABOR_SCHEDULE_FIXED_DATE, NON_LABOR_SCHEDULE_DISCOUNT NON_LABOR_SCHEDULE_DISCOUNT, LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG, PROJECT_LEVEL_FUNDING_FLAG PROJECT_LEVEL_FUNDING_FLAG, INVOICE_COMMENT INVOICE_COMMENT, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SUMMARY_FLAG SUMMARY_FLAG, ENABLED_FLAG ENABLED_FLAG, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID, REV_IND_RATE_SCH_ID REV_IND_RATE_SCH_ID, INV_IND_RATE_SCH_ID INV_IND_RATE_SCH_ID, COST_IND_SCH_FIXED_DATE COST_IND_SCH_FIXED_DATE, REV_IND_SCH_FIXED_DATE REV_IND_SCH_FIXED_DATE, INV_IND_SCH_FIXED_DATE INV_IND_SCH_FIXED_DATE, LABOR_SCH_TYPE LABOR_SCH_TYPE, NON_LABOR_SCH_TYPE NON_LABOR_SCH_TYPE, OVR_COST_IND_RATE_SCH_ID OVR_COST_IND_RATE_SCH_ID, OVR_REV_IND_RATE_SCH_ID OVR_REV_IND_RATE_SCH_ID, OVR_INV_IND_RATE_SCH_ID OVR_INV_IND_RATE_SCH_ID, TEMPLATE_FLAG TEMPLATE_FLAG, VERIFICATION_DATE VERIFICATION_DATE, CREATED_FROM_PROJECT_ID CREATED_FROM_PROJECT_ID, TEMPLATE_START_DATE_ACTIVE TEMPLATE_START_DATE_ACTIVE, TEMPLATE_END_DATE_ACTIVE TEMPLATE_END_DATE_ACTIVE, ORG_ID ORG_ID, PM_PRODUCT_CODE PM_PRODUCT_CODE, PM_PROJECT_REFERENCE PM_PROJECT_REFERENCE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE, EARLY_START_DATE EARLY_START_DATE, EARLY_FINISH_DATE EARLY_FINISH_DATE, LATE_START_DATE LATE_START_DATE, LATE_FINISH_DATE LATE_FINISH_DATE, SCHEDULED_START_DATE SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE, BILLING_CYCLE_ID BILLING_CYCLE_ID, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG, WF_STATUS_CODE WF_STATUS_CODE, OUTPUT_TAX_CODE OUTPUT_TAX_CODE, RETENTION_TAX_CODE RETENTION_TAX_CODE, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, ALLOW_CROSS_CHARGE_FLAG ALLOW_CROSS_CHARGE_FLAG, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, CC_PROCESS_LABOR_FLAG CC_PROCESS_LABOR_FLAG, LABOR_TP_SCHEDULE_ID LABOR_TP_SCHEDULE_ID, LABOR_TP_FIXED_DATE LABOR_TP_FIXED_DATE, CC_PROCESS_NL_FLAG CC_PROCESS_NL_FLAG, NL_TP_SCHEDULE_ID NL_TP_SCHEDULE_ID, NL_TP_FIXED_DATE NL_TP_FIXED_DATE, CC_TAX_TASK_ID CC_TAX_TASK_ID, BILL_JOB_GROUP_ID BILL_JOB_GROUP_ID, COST_JOB_GROUP_ID COST_JOB_GROUP_ID, ROLE_LIST_ID ROLE_LIST_ID, WORK_TYPE_ID WORK_TYPE_ID, CALENDAR_ID CALENDAR_ID, LOCATION_ID LOCATION_ID, PROBABILITY_MEMBER_ID PROBABILITY_MEMBER_ID, PROJECT_VALUE PROJECT_VALUE, EXPECTED_APPROVAL_DATE EXPECTED_APPROVAL_DATE, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, INITIAL_TEAM_TEMPLATE_ID INITIAL_TEAM_TEMPLATE_ID, JOB_BILL_RATE_SCHEDULE_ID JOB_BILL_RATE_SCHEDULE_ID, EMP_BILL_RATE_SCHEDULE_ID EMP_BILL_RATE_SCHEDULE_ID, COMPETENCE_MATCH_WT COMPETENCE_MATCH_WT, AVAILABILITY_MATCH_WT AVAILABILITY_MATCH_WT, JOB_LEVEL_MATCH_WT JOB_LEVEL_MATCH_WT, ENABLE_AUTOMATED_SEARCH ENABLE_AUTOMATED_SEARCH, SEARCH_MIN_AVAILABILITY SEARCH_MIN_AVAILABILITY, SEARCH_ORG_HIER_ID SEARCH_ORG_HIER_ID, SEARCH_STARTING_ORG_ID SEARCH_STARTING_ORG_ID, SEARCH_COUNTRY_CODE SEARCH_COUNTRY_CODE, MIN_CAND_SCORE_REQD_FOR_NOM MIN_CAND_SCORE_REQD_FOR_NOM, NON_LAB_STD_BILL_RT_SCH_ID NON_LAB_STD_BILL_RT_SCH_ID, INVPROC_CURRENCY_TYPE INVPROC_CURRENCY_TYPE, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE, PROJECT_BIL_RATE_DATE_CODE PROJECT_BIL_RATE_DATE_CODE, PROJECT_BIL_RATE_TYPE PROJECT_BIL_RATE_TYPE, PROJECT_BIL_RATE_DATE PROJECT_BIL_RATE_DATE, PROJECT_BIL_EXCHANGE_RATE PROJECT_BIL_EXCHANGE_RATE, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_BIL_RATE_DATE_CODE PROJFUNC_BIL_RATE_DATE_CODE, PROJFUNC_BIL_RATE_TYPE PROJFUNC_BIL_RATE_TYPE, PROJFUNC_BIL_RATE_DATE PROJFUNC_BIL_RATE_DATE, PROJFUNC_BIL_EXCHANGE_RATE PROJFUNC_BIL_EXCHANGE_RATE, FUNDING_RATE_DATE_CODE FUNDING_RATE_DATE_CODE, FUNDING_RATE_TYPE FUNDING_RATE_TYPE, FUNDING_RATE_DATE FUNDING_RATE_DATE, FUNDING_EXCHANGE_RATE FUNDING_EXCHANGE_RATE, BASELINE_FUNDING_FLAG BASELINE_FUNDING_FLAG, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, INV_BY_BILL_TRANS_CURR_FLAG INV_BY_BILL_TRANS_CURR_FLAG, MULTI_CURRENCY_BILLING_FLAG MULTI_CURRENCY_BILLING_FLAG, SPLIT_COST_FROM_WORKPLAN_FLAG SPLIT_COST_FROM_WORKPLAN_FLAG, SPLIT_COST_FROM_BILL_FLAG SPLIT_COST_FROM_BILL_FLAG, ASSIGN_PRECEDES_TASK ASSIGN_PRECEDES_TASK, PRIORITY_CODE PRIORITY_CODE, RETN_BILLING_INV_FORMAT_ID RETN_BILLING_INV_FORMAT_ID, RETN_ACCOUNTING_FLAG RETN_ACCOUNTING_FLAG, ADV_ACTION_SET_ID ADV_ACTION_SET_ID, START_ADV_ACTION_SET_FLAG START_ADV_ACTION_SET_FLAG, REVALUATE_FUNDING_FLAG REVALUATE_FUNDING_FLAG, INCLUDE_GAINS_LOSSES_FLAG INCLUDE_GAINS_LOSSES_FLAG, TARGET_START_DATE TARGET_START_DATE, TARGET_FINISH_DATE TARGET_FINISH_DATE, BASELINE_START_DATE BASELINE_START_DATE, BASELINE_FINISH_DATE BASELINE_FINISH_DATE, SCHEDULED_AS_OF_DATE SCHEDULED_AS_OF_DATE, BASELINE_AS_OF_DATE BASELINE_AS_OF_DATE, LABOR_DISC_REASON_CODE LABOR_DISC_REASON_CODE, NON_LABOR_DISC_REASON_CODE NON_LABOR_DISC_REASON_CODE, SECURITY_LEVEL SECURITY_LEVEL, ACTUAL_AS_OF_DATE ACTUAL_AS_OF_DATE, SCHEDULED_DURATION SCHEDULED_DURATION, BASELINE_DURATION BASELINE_DURATION, ACTUAL_DURATION ACTUAL_DURATION, LONG_NAME LONG_NAME, BTC_COST_BASE_REV_CODE BTC_COST_BASE_REV_CODE, ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD, CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING, CINT_RATE_SCH_ID CINT_RATE_SCH_ID, CINT_ELIGIBLE_FLAG CINT_ELIGIBLE_FLAG, CINT_STOP_DATE CINT_STOP_DATE, SYS_PROGRAM_FLAG SYS_PROGRAM_FLAG, STRUCTURE_SHARING_CODE STRUCTURE_SHARING_CODE, ENABLE_TOP_TASK_CUSTOMER_FLAG ENABLE_TOP_TASK_CUSTOMER_FLAG, ENABLE_TOP_TASK_INV_MTH_FLAG ENABLE_TOP_TASK_INV_MTH_FLAG, REVENUE_ACCRUAL_METHOD REVENUE_ACCRUAL_METHOD, INVOICE_METHOD INVOICE_METHOD, PROJFUNC_ATTR_FOR_AR_FLAG PROJFUNC_ATTR_FOR_AR_FLAG, PJI_SOURCE_FLAG PJI_SOURCE_FLAG, ALLOW_MULTI_PROGRAM_ROLLUP ALLOW_MULTI_PROGRAM_ROLLUP, PROJ_REQ_RES_FORMAT_ID PROJ_REQ_RES_FORMAT_ID, PROJ_ASGMT_RES_FORMAT_ID PROJ_ASGMT_RES_FORMAT_ID, FUNDING_APPROVAL_STATUS_CODE FUNDING_APPROVAL_STATUS_CODE, REVTRANS_CURRENCY_TYPE REVTRANS_CURRENCY_TYPE, DATE_EFF_FUNDS_CONSUMPTION DATE_EFF_FUNDS_CONSUMPTION, AR_REC_NOTIFY_FLAG AR_REC_NOTIFY_FLAG, AUTO_RELEASE_PWP_INV AUTO_RELEASE_PWP_INV, BILL_LABOR_ACCRUAL BILL_LABOR_ACCRUAL, ADJ_ON_STD_INV ADJ_ON_STD_INV, CBS_VERSION_ID CBS_VERSION_ID, CBS_ENABLE_FLAG CBS_ENABLE_FLAG, PJT_ROLLUP_ENABLED_FLAG PJT_ROLLUP_ENABLED_FLAG, OLAP_GROUP OLAP_GROUP, OLAP_TASK_ID OLAP_TASK_ID from "PA"."PA_PROJECTS_ALL"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, NAME NAME
, SEGMENT1 SEGMENT1
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROJECT_TYPE PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID CARRYING_OUT_ORGANIZATION_ID
, PUBLIC_SECTOR_FLAG PUBLIC_SECTOR_FLAG
, PROJECT_STATUS_CODE PROJECT_STATUS_CODE
, DESCRIPTION DESCRIPTION
, START_DATE START_DATE
, COMPLETION_DATE COMPLETION_DATE
, CLOSED_DATE CLOSED_DATE
, DISTRIBUTION_RULE DISTRIBUTION_RULE
, LABOR_INVOICE_FORMAT_ID LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID NON_LABOR_INVOICE_FORMAT_ID
, RETENTION_INVOICE_FORMAT_ID RETENTION_INVOICE_FORMAT_ID
, RETENTION_PERCENTAGE RETENTION_PERCENTAGE
, BILLING_OFFSET BILLING_OFFSET
, BILLING_CYCLE BILLING_CYCLE
, LABOR_STD_BILL_RATE_SCHDL LABOR_STD_BILL_RATE_SCHDL
, LABOR_BILL_RATE_ORG_ID LABOR_BILL_RATE_ORG_ID
, LABOR_SCHEDULE_FIXED_DATE LABOR_SCHEDULE_FIXED_DATE
, LABOR_SCHEDULE_DISCOUNT LABOR_SCHEDULE_DISCOUNT
, NON_LABOR_STD_BILL_RATE_SCHDL NON_LABOR_STD_BILL_RATE_SCHDL
, NON_LABOR_BILL_RATE_ORG_ID NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_SCHEDULE_FIXED_DATE NON_LABOR_SCHEDULE_FIXED_DATE
, NON_LABOR_SCHEDULE_DISCOUNT NON_LABOR_SCHEDULE_DISCOUNT
, LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG
, PROJECT_LEVEL_FUNDING_FLAG PROJECT_LEVEL_FUNDING_FLAG
, INVOICE_COMMENT INVOICE_COMMENT
, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SUMMARY_FLAG SUMMARY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID
, REV_IND_RATE_SCH_ID REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID INV_IND_RATE_SCH_ID
, COST_IND_SCH_FIXED_DATE COST_IND_SCH_FIXED_DATE
, REV_IND_SCH_FIXED_DATE REV_IND_SCH_FIXED_DATE
, INV_IND_SCH_FIXED_DATE INV_IND_SCH_FIXED_DATE
, LABOR_SCH_TYPE LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE NON_LABOR_SCH_TYPE
, OVR_COST_IND_RATE_SCH_ID OVR_COST_IND_RATE_SCH_ID
, OVR_REV_IND_RATE_SCH_ID OVR_REV_IND_RATE_SCH_ID
, OVR_INV_IND_RATE_SCH_ID OVR_INV_IND_RATE_SCH_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, VERIFICATION_DATE VERIFICATION_DATE
, CREATED_FROM_PROJECT_ID CREATED_FROM_PROJECT_ID
, TEMPLATE_START_DATE_ACTIVE TEMPLATE_START_DATE_ACTIVE
, TEMPLATE_END_DATE_ACTIVE TEMPLATE_END_DATE_ACTIVE
, ORG_ID ORG_ID
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, PM_PROJECT_REFERENCE PM_PROJECT_REFERENCE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE
, EARLY_START_DATE EARLY_START_DATE
, EARLY_FINISH_DATE EARLY_FINISH_DATE
, LATE_START_DATE LATE_START_DATE
, LATE_FINISH_DATE LATE_FINISH_DATE
, SCHEDULED_START_DATE SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE
, BILLING_CYCLE_ID BILLING_CYCLE_ID
, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG
, WF_STATUS_CODE WF_STATUS_CODE
, OUTPUT_TAX_CODE OUTPUT_TAX_CODE
, RETENTION_TAX_CODE RETENTION_TAX_CODE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, CC_PROCESS_LABOR_FLAG CC_PROCESS_LABOR_FLAG
, LABOR_TP_SCHEDULE_ID LABOR_TP_SCHEDULE_ID
, LABOR_TP_FIXED_DATE LABOR_TP_FIXED_DATE
, CC_PROCESS_NL_FLAG CC_PROCESS_NL_FLAG
, NL_TP_SCHEDULE_ID NL_TP_SCHEDULE_ID
, NL_TP_FIXED_DATE NL_TP_FIXED_DATE
, CC_TAX_TASK_ID CC_TAX_TASK_ID
, BILL_JOB_GROUP_ID BILL_JOB_GROUP_ID
, COST_JOB_GROUP_ID COST_JOB_GROUP_ID
, ROLE_LIST_ID ROLE_LIST_ID
, WORK_TYPE_ID WORK_TYPE_ID
, CALENDAR_ID CALENDAR_ID
, LOCATION_ID LOCATION_ID
, PROBABILITY_MEMBER_ID PROBABILITY_MEMBER_ID
, PROJECT_VALUE PROJECT_VALUE
, EXPECTED_APPROVAL_DATE EXPECTED_APPROVAL_DATE
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, INITIAL_TEAM_TEMPLATE_ID INITIAL_TEAM_TEMPLATE_ID
, JOB_BILL_RATE_SCHEDULE_ID JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID EMP_BILL_RATE_SCHEDULE_ID
, COMPETENCE_MATCH_WT COMPETENCE_MATCH_WT
, AVAILABILITY_MATCH_WT AVAILABILITY_MATCH_WT
, JOB_LEVEL_MATCH_WT JOB_LEVEL_MATCH_WT
, ENABLE_AUTOMATED_SEARCH ENABLE_AUTOMATED_SEARCH
, SEARCH_MIN_AVAILABILITY SEARCH_MIN_AVAILABILITY
, SEARCH_ORG_HIER_ID SEARCH_ORG_HIER_ID
, SEARCH_STARTING_ORG_ID SEARCH_STARTING_ORG_ID
, SEARCH_COUNTRY_CODE SEARCH_COUNTRY_CODE
, MIN_CAND_SCORE_REQD_FOR_NOM MIN_CAND_SCORE_REQD_FOR_NOM
, NON_LAB_STD_BILL_RT_SCH_ID NON_LAB_STD_BILL_RT_SCH_ID
, INVPROC_CURRENCY_TYPE INVPROC_CURRENCY_TYPE
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, PROJECT_BIL_RATE_DATE_CODE PROJECT_BIL_RATE_DATE_CODE
, PROJECT_BIL_RATE_TYPE PROJECT_BIL_RATE_TYPE
, PROJECT_BIL_RATE_DATE PROJECT_BIL_RATE_DATE
, PROJECT_BIL_EXCHANGE_RATE PROJECT_BIL_EXCHANGE_RATE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_BIL_RATE_DATE_CODE PROJFUNC_BIL_RATE_DATE_CODE
, PROJFUNC_BIL_RATE_TYPE PROJFUNC_BIL_RATE_TYPE
, PROJFUNC_BIL_RATE_DATE PROJFUNC_BIL_RATE_DATE
, PROJFUNC_BIL_EXCHANGE_RATE PROJFUNC_BIL_EXCHANGE_RATE
, FUNDING_RATE_DATE_CODE FUNDING_RATE_DATE_CODE
, FUNDING_RATE_TYPE FUNDING_RATE_TYPE
, FUNDING_RATE_DATE FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE FUNDING_EXCHANGE_RATE
, BASELINE_FUNDING_FLAG BASELINE_FUNDING_FLAG
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, INV_BY_BILL_TRANS_CURR_FLAG INV_BY_BILL_TRANS_CURR_FLAG
, MULTI_CURRENCY_BILLING_FLAG MULTI_CURRENCY_BILLING_FLAG
, SPLIT_COST_FROM_WORKPLAN_FLAG SPLIT_COST_FROM_WORKPLAN_FLAG
, SPLIT_COST_FROM_BILL_FLAG SPLIT_COST_FROM_BILL_FLAG
, ASSIGN_PRECEDES_TASK ASSIGN_PRECEDES_TASK
, PRIORITY_CODE PRIORITY_CODE
, RETN_BILLING_INV_FORMAT_ID RETN_BILLING_INV_FORMAT_ID
, RETN_ACCOUNTING_FLAG RETN_ACCOUNTING_FLAG
, ADV_ACTION_SET_ID ADV_ACTION_SET_ID
, START_ADV_ACTION_SET_FLAG START_ADV_ACTION_SET_FLAG
, REVALUATE_FUNDING_FLAG REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG INCLUDE_GAINS_LOSSES_FLAG
, TARGET_START_DATE TARGET_START_DATE
, TARGET_FINISH_DATE TARGET_FINISH_DATE
, BASELINE_START_DATE BASELINE_START_DATE
, BASELINE_FINISH_DATE BASELINE_FINISH_DATE
, SCHEDULED_AS_OF_DATE SCHEDULED_AS_OF_DATE
, BASELINE_AS_OF_DATE BASELINE_AS_OF_DATE
, LABOR_DISC_REASON_CODE LABOR_DISC_REASON_CODE
, NON_LABOR_DISC_REASON_CODE NON_LABOR_DISC_REASON_CODE
, SECURITY_LEVEL SECURITY_LEVEL
, ACTUAL_AS_OF_DATE ACTUAL_AS_OF_DATE
, SCHEDULED_DURATION SCHEDULED_DURATION
, BASELINE_DURATION BASELINE_DURATION
, ACTUAL_DURATION ACTUAL_DURATION
, LONG_NAME LONG_NAME
, BTC_COST_BASE_REV_CODE BTC_COST_BASE_REV_CODE
, ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID CINT_RATE_SCH_ID
, CINT_ELIGIBLE_FLAG CINT_ELIGIBLE_FLAG
, CINT_STOP_DATE CINT_STOP_DATE
, SYS_PROGRAM_FLAG SYS_PROGRAM_FLAG
, STRUCTURE_SHARING_CODE STRUCTURE_SHARING_CODE
, ENABLE_TOP_TASK_CUSTOMER_FLAG ENABLE_TOP_TASK_CUSTOMER_FLAG
, ENABLE_TOP_TASK_INV_MTH_FLAG ENABLE_TOP_TASK_INV_MTH_FLAG
, REVENUE_ACCRUAL_METHOD REVENUE_ACCRUAL_METHOD
, INVOICE_METHOD INVOICE_METHOD
, PROJFUNC_ATTR_FOR_AR_FLAG PROJFUNC_ATTR_FOR_AR_FLAG
, PJI_SOURCE_FLAG PJI_SOURCE_FLAG
, ALLOW_MULTI_PROGRAM_ROLLUP ALLOW_MULTI_PROGRAM_ROLLUP
, PROJ_REQ_RES_FORMAT_ID PROJ_REQ_RES_FORMAT_ID
, PROJ_ASGMT_RES_FORMAT_ID PROJ_ASGMT_RES_FORMAT_ID
, FUNDING_APPROVAL_STATUS_CODE FUNDING_APPROVAL_STATUS_CODE
, REVTRANS_CURRENCY_TYPE REVTRANS_CURRENCY_TYPE
, DATE_EFF_FUNDS_CONSUMPTION DATE_EFF_FUNDS_CONSUMPTION
, AR_REC_NOTIFY_FLAG AR_REC_NOTIFY_FLAG
, AUTO_RELEASE_PWP_INV AUTO_RELEASE_PWP_INV
, BILL_LABOR_ACCRUAL BILL_LABOR_ACCRUAL
, ADJ_ON_STD_INV ADJ_ON_STD_INV
, CBS_VERSION_ID CBS_VERSION_ID
, CBS_ENABLE_FLAG CBS_ENABLE_FLAG
, PJT_ROLLUP_ENABLED_FLAG PJT_ROLLUP_ENABLED_FLAG
, OLAP_GROUP OLAP_GROUP
, OLAP_TASK_ID OLAP_TASK_ID
FROM "PA"."PA_PROJECTS_ALL"