View: PA_PROJECTS_V_O

View Text

SELECT PROJ.ROWID ROW_ID
, PROJ.PROJECT_ID
, PROJ.NAME
, PROJ.SEGMENT1
, PROJ.LAST_UPDATE_DATE
, PROJ.LAST_UPDATED_BY
, PROJ.CREATION_DATE
, PROJ.CREATED_BY
, PROJ.LAST_UPDATE_LOGIN
, PROJ.PROJECT_TYPE
, PROJ.CARRYING_OUT_ORGANIZATION_ID
, PROJ.PUBLIC_SECTOR_FLAG
, PROJ.PROJECT_STATUS_CODE
, PROJ.DESCRIPTION
, PROJ.START_DATE
, PROJ.COMPLETION_DATE
, PROJ.CLOSED_DATE
, PROJ.DISTRIBUTION_RULE
, PROJ.LABOR_INVOICE_FORMAT_ID
, PROJ.NON_LABOR_INVOICE_FORMAT_ID
, PROJ.RETENTION_INVOICE_FORMAT_ID
, PROJ.RETENTION_PERCENTAGE
, PROJ.BILLING_OFFSET
, PROJ.BILLING_CYCLE
, PROJ.BILLING_CYCLE_ID
, BILL.BILLING_CYCLE_NAME
, PROJ.LABOR_STD_BILL_RATE_SCHDL
, PROJ.LABOR_BILL_RATE_ORG_ID
, PROJ.LABOR_SCHEDULE_FIXED_DATE
, PROJ.LABOR_SCHEDULE_DISCOUNT
, PROJ.NON_LABOR_STD_BILL_RATE_SCHDL
, PROJ.NON_LABOR_BILL_RATE_ORG_ID
, PROJ.NON_LABOR_SCHEDULE_FIXED_DATE
, PROJ.NON_LABOR_SCHEDULE_DISCOUNT
, PROJ.LIMIT_TO_TXN_CONTROLS_FLAG
, PROJ.PROJECT_LEVEL_FUNDING_FLAG
, PROJ.INVOICE_COMMENT
, PROJ.UNBILLED_RECEIVABLE_DR
, PROJ.UNEARNED_REVENUE_CR
, PROJ.REQUEST_ID
, PROJ.PROGRAM_ID
, PROJ.PROGRAM_APPLICATION_ID
, PROJ.PROGRAM_UPDATE_DATE
, PROJ.SUMMARY_FLAG
, PROJ.ENABLED_FLAG
, PROJ.SEGMENT2
, PROJ.SEGMENT3
, PROJ.SEGMENT4
, PROJ.SEGMENT5
, PROJ.SEGMENT6
, PROJ.SEGMENT7
, PROJ.SEGMENT8
, PROJ.SEGMENT9
, PROJ.SEGMENT10
, PROJ.ATTRIBUTE_CATEGORY
, PROJ.ATTRIBUTE1
, PROJ.ATTRIBUTE2
, PROJ.ATTRIBUTE3
, PROJ.ATTRIBUTE4
, PROJ.ATTRIBUTE5
, PROJ.ATTRIBUTE6
, PROJ.ATTRIBUTE7
, PROJ.ATTRIBUTE8
, PROJ.ATTRIBUTE9
, PROJ.ATTRIBUTE10
, PROJ.COST_IND_RATE_SCH_ID
, PROJ.REV_IND_RATE_SCH_ID
, PROJ.INV_IND_RATE_SCH_ID
, PROJ.COST_IND_SCH_FIXED_DATE
, PROJ.REV_IND_SCH_FIXED_DATE
, PROJ.INV_IND_SCH_FIXED_DATE
, PROJ.LABOR_SCH_TYPE
, PROJ.NON_LABOR_SCH_TYPE
, PROJ.TEMPLATE_FLAG
, PROJ.CREATED_FROM_PROJECT_ID
, PROJ.VERIFICATION_DATE
, PROJ.TEMPLATE_START_DATE_ACTIVE
, PROJ.TEMPLATE_END_DATE_ACTIVE
, ORG.NAME ORGANIZATION_NAME
, PS.PROJECT_STATUS_NAME
, RULE.MEANING DISTRIBUTION_RULE_M
, RULE.DESCRIPTION DISTRIBUTION_RULE_DESCRIPTION
, TYPE.PROJECT_TYPE_CLASS_CODE
, TYPE.SERVICE_TYPE_CODE
, TYPE.BURDEN_COST_FLAG
, TYPE.INTERFACE_ASSET_COST_CODE
, TYPE.COST_SCH_OVERRIDE_FLAG
, TYPE.CC_PRVDR_FLAG
, PA_SECURITY.ALLOW_UPDATE(PROJ.PROJECT_ID)
, PROJ.PM_PRODUCT_CODE
, LK1.MEANING PM_PRODUCT_CODE_M
, PROJ.PM_PROJECT_REFERENCE
, PROJ.ACTUAL_START_DATE
, PROJ.ACTUAL_FINISH_DATE
, PROJ.EARLY_START_DATE
, PROJ.EARLY_FINISH_DATE
, PROJ.LATE_START_DATE
, PROJ.LATE_FINISH_DATE
, PROJ.SCHEDULED_START_DATE
, PROJ.SCHEDULED_FINISH_DATE
, PROJ.WF_STATUS_CODE
, DECODE(PROJ.WF_STATUS_CODE
, NULL
, 'N'
, 'Y')
, PS.PROJECT_SYSTEM_STATUS_CODE
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.ALLOW_CROSS_CHARGE_FLAG
, PROJ.PROJECT_RATE_DATE
, PROJ.PROJECT_RATE_TYPE
, PROJ.OUTPUT_TAX_CODE
, PROJ.RETENTION_TAX_CODE
, PROJ.CC_PROCESS_LABOR_FLAG
, PROJ.LABOR_TP_SCHEDULE_ID
, PROJ.LABOR_TP_FIXED_DATE
, PROJ.CC_PROCESS_NL_FLAG
, PROJ.NL_TP_SCHEDULE_ID
, PROJ.NL_TP_FIXED_DATE
, PROJ.CC_TAX_TASK_ID
, PROJ.BILL_JOB_GROUP_ID
, PROJ.COST_JOB_GROUP_ID
, PROJ.ROLE_LIST_ID
, PROJ.WORK_TYPE_ID
, PROJ.CALENDAR_ID
, PROJ.LOCATION_ID
, PROJ.PROBABILITY_MEMBER_ID
, PROJ.PROJECT_VALUE
, PROJ.EXPECTED_APPROVAL_DATE
, TYPE.UNASSIGNED_TIME
, TYPE.ADMINISTRATIVE_FLAG
, PROJ.INITIAL_TEAM_TEMPLATE_ID
, PROJ.RECORD_VERSION_NUMBER
, PROJ.JOB_BILL_RATE_SCHEDULE_ID
, PROJ.EMP_BILL_RATE_SCHEDULE_ID
FROM HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_STATUSES PS
, PA_LOOKUPS LK1
, PA_DISTRIBUTION_RULES RULE
, PA_BILLING_CYCLES BILL
, PA_PROJECT_TYPES TYPE
, PA_PROJECTS PROJ
WHERE 'Y' IN (SELECT PA_SECURITY.ALLOW_QUERY(PROJ.PROJECT_ID)
FROM SYS.DUAL)
AND PROJ.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND PROJ.PROJECT_STATUS_CODE = PS.PROJECT_STATUS_CODE
AND PROJ.PM_PRODUCT_CODE = LK1.LOOKUP_CODE (+)
AND LK1.LOOKUP_TYPE (+)= 'PM_PRODUCT_CODE'
AND PROJ.DISTRIBUTION_RULE = RULE.DISTRIBUTION_RULE (+)
AND PROJ.BILLING_CYCLE_ID = BILL.BILLING_CYCLE_ID (+)
AND PROJ.PROJECT_TYPE = TYPE.PROJECT_TYPE
AND PS.STATUS_TYPE = 'PROJECT'

Columns