Product: | PA - Projects |
---|---|
Description: | Single-Org |
Implementation/DBA Data: | Not implemented in this database |
SELECT PROJECT_ID
, NAME
, LONG_NAME
, SEGMENT1
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID
, PUBLIC_SECTOR_FLAG
, PROJECT_STATUS_CODE
, DESCRIPTION
, START_DATE
, COMPLETION_DATE
, CLOSED_DATE
, DISTRIBUTION_RULE
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, RETENTION_INVOICE_FORMAT_ID
, RETENTION_PERCENTAGE
, BILLING_OFFSET
, BILLING_CYCLE
, BILLING_CYCLE_ID
, LABOR_STD_BILL_RATE_SCHDL
, LABOR_BILL_RATE_ORG_ID
, LABOR_SCHEDULE_FIXED_DATE
, LABOR_SCHEDULE_DISCOUNT
, TEMPLATE_FLAG
, VERIFICATION_DATE
, CREATED_FROM_PROJECT_ID
, TEMPLATE_START_DATE_ACTIVE
, NON_LABOR_STD_BILL_RATE_SCHDL
, TEMPLATE_END_DATE_ACTIVE
, NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_SCHEDULE_FIXED_DATE
, NON_LABOR_SCHEDULE_DISCOUNT
, LIMIT_TO_TXN_CONTROLS_FLAG
, PROJECT_LEVEL_FUNDING_FLAG
, INVOICE_COMMENT
, UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR
, 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
, REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID
, COST_IND_SCH_FIXED_DATE
, REV_IND_SCH_FIXED_DATE
, INV_IND_SCH_FIXED_DATE
, LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE
, OVR_COST_IND_RATE_SCH_ID
, OVR_REV_IND_RATE_SCH_ID
, OVR_INV_IND_RATE_SCH_ID
, ORG_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
, ADW_NOTIFY_FLAG
, WF_STATUS_CODE
, PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, OUTPUT_TAX_CODE
, RETENTION_TAX_CODE
, CC_PROCESS_LABOR_FLAG
, LABOR_TP_SCHEDULE_ID
, LABOR_TP_FIXED_DATE
, CC_PROCESS_NL_FLAG
, NL_TP_SCHEDULE_ID
, NL_TP_FIXED_DATE
, CC_TAX_TASK_ID
, COST_JOB_GROUP_ID
, BILL_JOB_GROUP_ID
, ROLE_LIST_ID
, WORK_TYPE_ID
, CALENDAR_ID
, LOCATION_ID
, PROBABILITY_MEMBER_ID
, PROJECT_VALUE
, EXPECTED_APPROVAL_DATE
, INITIAL_TEAM_TEMPLATE_ID
, RECORD_VERSION_NUMBER
, JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID
, NON_LAB_STD_BILL_RT_SCH_ID
, INVPROC_CURRENCY_TYPE
, REVPROC_CURRENCY_CODE
, PROJECT_BIL_RATE_DATE_CODE
, PROJECT_BIL_RATE_TYPE
, PROJECT_BIL_RATE_DATE
, PROJECT_BIL_EXCHANGE_RATE
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_BIL_RATE_DATE_CODE
, PROJFUNC_BIL_RATE_TYPE
, PROJFUNC_BIL_RATE_DATE
, PROJFUNC_BIL_EXCHANGE_RATE
, FUNDING_RATE_DATE_CODE
, FUNDING_RATE_TYPE
, FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE
, BASELINE_FUNDING_FLAG
, MULTI_CURRENCY_BILLING_FLAG
, COMPETENCE_MATCH_WT
, AVAILABILITY_MATCH_WT
, JOB_LEVEL_MATCH_WT
, ENABLE_AUTOMATED_SEARCH
, SEARCH_MIN_AVAILABILITY
, SEARCH_ORG_HIER_ID
, SEARCH_STARTING_ORG_ID
, SEARCH_COUNTRY_CODE
, MIN_CAND_SCORE_REQD_FOR_NOM
, INV_BY_BILL_TRANS_CURR_FLAG
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, ASSIGN_PRECEDES_TASK
, SPLIT_COST_FROM_WORKPLAN_FLAG
, SPLIT_COST_FROM_BILL_FLAG
, PRIORITY_CODE
, RETN_BILLING_INV_FORMAT_ID
, RETN_ACCOUNTING_FLAG
, ADV_ACTION_SET_ID
, START_ADV_ACTION_SET_FLAG
, TARGET_START_DATE
, TARGET_FINISH_DATE
, BASELINE_START_DATE
, BASELINE_FINISH_DATE
, REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG
, SCHEDULED_AS_OF_DATE
, BASELINE_AS_OF_DATE
, SECURITY_LEVEL
, LABOR_DISC_REASON_CODE
, NON_LABOR_DISC_REASON_CODE
, ACTUAL_AS_OF_DATE
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(SCHEDULED_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(BASELINE_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(ACTUAL_DURATION)
, BTC_COST_BASE_REV_CODE
, ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID
, CINT_ELIGIBLE_FLAG
, CINT_STOP_DATE
, STRUCTURE_SHARING_CODE
, ENABLE_TOP_TASK_CUSTOMER_FLAG
, ENABLE_TOP_TASK_INV_MTH_FLAG
, REVENUE_ACCRUAL_METHOD
, INVOICE_METHOD
, PROJFUNC_ATTR_FOR_AR_FLAG
, SYS_PROGRAM_FLAG
, ALLOW_MULTI_PROGRAM_ROLLUP
, PROJ_REQ_RES_FORMAT_ID
, PROJ_ASGMT_RES_FORMAT_ID
, PJI_SOURCE_FLAG
, FUNDING_APPROVAL_STATUS_CODE
FROM PA_PROJECTS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)