View: PA_PROJECT_TYPES

View Text

SELECT PROJECT_TYPE_ID
, PROJECT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DIRECT_FLAG
, SERVICE_TYPE_CODE
, BURDEN_COST_FLAG
, TOTAL_BURDEN_FLAG
, START_DATE_ACTIVE
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, LABOR_BILL_RATE_ORG_ID
, LABOR_STD_BILL_RATE_SCHDL
, NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_STD_BILL_RATE_SCHDL
, END_DATE_ACTIVE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE
, COST_IND_RATE_SCH_ID
, REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID
, COST_SCH_OVERRIDE_FLAG
, REV_BUDGET_ENTRY_METHOD_CODE
, REV_BUDGET_RESOURCE_LIST_ID
, ALLOW_REV_BUDGET_ENTRY_FLAG
, COST_BUDGET_ENTRY_METHOD_CODE
, COST_BUDGET_RESOURCE_LIST_ID
, ALLOW_COST_BUDGET_ENTRY_FLAG
, DEFAULT_RESOURCE_LIST_ID
, ALLOWABLE_FUNDING_LEVEL_CODE
, PROJECT_TYPE_CLASS_CODE
, INTERFACE_COMPLETE_ASSET_FLAG
, CIP_GROUPING_METHOD_CODE
, CAPITAL_COST_TYPE_CODE
, INTERFACE_ASSET_COST_CODE
, BILLING_OFFSET
, BILLING_CYCLE_ID
, ENABLE_PROJECT_WF_FLAG
, ENABLE_BUDGET_WF_FLAG
, ORG_ID
, ADW_NOTIFY_FLAG
, DEF_START_PROJ_STATUS_CODE
, BURDEN_AMT_DISPLAY_METHOD
, BURDEN_ACCOUNT_FLAG
, BURDEN_SUM_DEST_PROJECT_ID
, BURDEN_SUM_DEST_TASK_ID
, VENDOR_INVOICE_GROUPING_CODE
, OVERRIDE_ASSET_ASSIGNMENT_FLAG
, CC_PRVDR_FLAG
, BILL_JOB_GROUP_ID
, COST_JOB_GROUP_ID
, ADMINISTRATIVE_FLAG
, ROLE_LIST_ID
, WORK_TYPE_ID
, PROBABILITY_LIST_ID
, UNASSIGNED_TIME
, JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID
, BUDGETARY_OVERRIDE_FLAG
, BASELINE_FUNDING_FLAG
, NON_LAB_STD_BILL_RT_SCH_ID
, ORG_PROJECT_FLAG
, REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG
, RLZD_GAINS_EVENT_TYPE_ID
, RLZD_LOSSES_EVENT_TYPE_ID
, ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID
, CINT_SCH_OVERRIDE_FLAG
FROM PA_PROJECT_TYPES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns