View: PA_PROJECTS_O

View Text

SELECT PROJECT_ID
, 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
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)

Columns