VIEW: PA.PA_PROJ_PERIODS_DENORM#

Source

View Text - Preformatted

select BUDGET_VERSION_ID BUDGET_VERSION_ID, PROJECT_ID PROJECT_ID, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID, OBJECT_ID OBJECT_ID, OBJECT_TYPE_CODE OBJECT_TYPE_CODE, PERIOD_PROFILE_ID PERIOD_PROFILE_ID, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE, AMOUNT_SUBTYPE_CODE AMOUNT_SUBTYPE_CODE, AMOUNT_TYPE_ID AMOUNT_TYPE_ID, AMOUNT_SUBTYPE_ID AMOUNT_SUBTYPE_ID, CURRENCY_TYPE CURRENCY_TYPE, CURRENCY_CODE CURRENCY_CODE, PRECEDING_PERIODS_AMOUNT PRECEDING_PERIODS_AMOUNT, SUCCEEDING_PERIODS_AMOUNT SUCCEEDING_PERIODS_AMOUNT, PRIOR_PERIOD_AMOUNT PRIOR_PERIOD_AMOUNT, PERIOD_AMOUNT1 PERIOD_AMOUNT1, PERIOD_AMOUNT2 PERIOD_AMOUNT2, PERIOD_AMOUNT3 PERIOD_AMOUNT3, PERIOD_AMOUNT4 PERIOD_AMOUNT4, PERIOD_AMOUNT5 PERIOD_AMOUNT5, PERIOD_AMOUNT6 PERIOD_AMOUNT6, PERIOD_AMOUNT7 PERIOD_AMOUNT7, PERIOD_AMOUNT8 PERIOD_AMOUNT8, PERIOD_AMOUNT9 PERIOD_AMOUNT9, PERIOD_AMOUNT10 PERIOD_AMOUNT10, PERIOD_AMOUNT11 PERIOD_AMOUNT11, PERIOD_AMOUNT12 PERIOD_AMOUNT12, PERIOD_AMOUNT13 PERIOD_AMOUNT13, PERIOD_AMOUNT14 PERIOD_AMOUNT14, PERIOD_AMOUNT15 PERIOD_AMOUNT15, PERIOD_AMOUNT16 PERIOD_AMOUNT16, PERIOD_AMOUNT17 PERIOD_AMOUNT17, PERIOD_AMOUNT18 PERIOD_AMOUNT18, PERIOD_AMOUNT19 PERIOD_AMOUNT19, PERIOD_AMOUNT20 PERIOD_AMOUNT20, PERIOD_AMOUNT21 PERIOD_AMOUNT21, PERIOD_AMOUNT22 PERIOD_AMOUNT22, PERIOD_AMOUNT23 PERIOD_AMOUNT23, PERIOD_AMOUNT24 PERIOD_AMOUNT24, PERIOD_AMOUNT25 PERIOD_AMOUNT25, PERIOD_AMOUNT26 PERIOD_AMOUNT26, PERIOD_AMOUNT27 PERIOD_AMOUNT27, PERIOD_AMOUNT28 PERIOD_AMOUNT28, PERIOD_AMOUNT29 PERIOD_AMOUNT29, PERIOD_AMOUNT30 PERIOD_AMOUNT30, PERIOD_AMOUNT31 PERIOD_AMOUNT31, PERIOD_AMOUNT32 PERIOD_AMOUNT32, PERIOD_AMOUNT33 PERIOD_AMOUNT33, PERIOD_AMOUNT34 PERIOD_AMOUNT34, PERIOD_AMOUNT35 PERIOD_AMOUNT35, PERIOD_AMOUNT36 PERIOD_AMOUNT36, PERIOD_AMOUNT37 PERIOD_AMOUNT37, PERIOD_AMOUNT38 PERIOD_AMOUNT38, PERIOD_AMOUNT39 PERIOD_AMOUNT39, PERIOD_AMOUNT40 PERIOD_AMOUNT40, PERIOD_AMOUNT41 PERIOD_AMOUNT41, PERIOD_AMOUNT42 PERIOD_AMOUNT42, PERIOD_AMOUNT43 PERIOD_AMOUNT43, PERIOD_AMOUNT44 PERIOD_AMOUNT44, PERIOD_AMOUNT45 PERIOD_AMOUNT45, PERIOD_AMOUNT46 PERIOD_AMOUNT46, PERIOD_AMOUNT47 PERIOD_AMOUNT47, PERIOD_AMOUNT48 PERIOD_AMOUNT48, PERIOD_AMOUNT49 PERIOD_AMOUNT49, PERIOD_AMOUNT50 PERIOD_AMOUNT50, PERIOD_AMOUNT51 PERIOD_AMOUNT51, PERIOD_AMOUNT52 PERIOD_AMOUNT52, 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, PARENT_ASSIGNMENT_ID PARENT_ASSIGNMENT_ID from "PA"."PA_PROJ_PERIODS_DENORM"

View Text - HTML Formatted

SELECT BUDGET_VERSION_ID BUDGET_VERSION_ID
, PROJECT_ID PROJECT_ID
, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE_CODE OBJECT_TYPE_CODE
, PERIOD_PROFILE_ID PERIOD_PROFILE_ID
, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE
, AMOUNT_SUBTYPE_CODE AMOUNT_SUBTYPE_CODE
, AMOUNT_TYPE_ID AMOUNT_TYPE_ID
, AMOUNT_SUBTYPE_ID AMOUNT_SUBTYPE_ID
, CURRENCY_TYPE CURRENCY_TYPE
, CURRENCY_CODE CURRENCY_CODE
, PRECEDING_PERIODS_AMOUNT PRECEDING_PERIODS_AMOUNT
, SUCCEEDING_PERIODS_AMOUNT SUCCEEDING_PERIODS_AMOUNT
, PRIOR_PERIOD_AMOUNT PRIOR_PERIOD_AMOUNT
, PERIOD_AMOUNT1 PERIOD_AMOUNT1
, PERIOD_AMOUNT2 PERIOD_AMOUNT2
, PERIOD_AMOUNT3 PERIOD_AMOUNT3
, PERIOD_AMOUNT4 PERIOD_AMOUNT4
, PERIOD_AMOUNT5 PERIOD_AMOUNT5
, PERIOD_AMOUNT6 PERIOD_AMOUNT6
, PERIOD_AMOUNT7 PERIOD_AMOUNT7
, PERIOD_AMOUNT8 PERIOD_AMOUNT8
, PERIOD_AMOUNT9 PERIOD_AMOUNT9
, PERIOD_AMOUNT10 PERIOD_AMOUNT10
, PERIOD_AMOUNT11 PERIOD_AMOUNT11
, PERIOD_AMOUNT12 PERIOD_AMOUNT12
, PERIOD_AMOUNT13 PERIOD_AMOUNT13
, PERIOD_AMOUNT14 PERIOD_AMOUNT14
, PERIOD_AMOUNT15 PERIOD_AMOUNT15
, PERIOD_AMOUNT16 PERIOD_AMOUNT16
, PERIOD_AMOUNT17 PERIOD_AMOUNT17
, PERIOD_AMOUNT18 PERIOD_AMOUNT18
, PERIOD_AMOUNT19 PERIOD_AMOUNT19
, PERIOD_AMOUNT20 PERIOD_AMOUNT20
, PERIOD_AMOUNT21 PERIOD_AMOUNT21
, PERIOD_AMOUNT22 PERIOD_AMOUNT22
, PERIOD_AMOUNT23 PERIOD_AMOUNT23
, PERIOD_AMOUNT24 PERIOD_AMOUNT24
, PERIOD_AMOUNT25 PERIOD_AMOUNT25
, PERIOD_AMOUNT26 PERIOD_AMOUNT26
, PERIOD_AMOUNT27 PERIOD_AMOUNT27
, PERIOD_AMOUNT28 PERIOD_AMOUNT28
, PERIOD_AMOUNT29 PERIOD_AMOUNT29
, PERIOD_AMOUNT30 PERIOD_AMOUNT30
, PERIOD_AMOUNT31 PERIOD_AMOUNT31
, PERIOD_AMOUNT32 PERIOD_AMOUNT32
, PERIOD_AMOUNT33 PERIOD_AMOUNT33
, PERIOD_AMOUNT34 PERIOD_AMOUNT34
, PERIOD_AMOUNT35 PERIOD_AMOUNT35
, PERIOD_AMOUNT36 PERIOD_AMOUNT36
, PERIOD_AMOUNT37 PERIOD_AMOUNT37
, PERIOD_AMOUNT38 PERIOD_AMOUNT38
, PERIOD_AMOUNT39 PERIOD_AMOUNT39
, PERIOD_AMOUNT40 PERIOD_AMOUNT40
, PERIOD_AMOUNT41 PERIOD_AMOUNT41
, PERIOD_AMOUNT42 PERIOD_AMOUNT42
, PERIOD_AMOUNT43 PERIOD_AMOUNT43
, PERIOD_AMOUNT44 PERIOD_AMOUNT44
, PERIOD_AMOUNT45 PERIOD_AMOUNT45
, PERIOD_AMOUNT46 PERIOD_AMOUNT46
, PERIOD_AMOUNT47 PERIOD_AMOUNT47
, PERIOD_AMOUNT48 PERIOD_AMOUNT48
, PERIOD_AMOUNT49 PERIOD_AMOUNT49
, PERIOD_AMOUNT50 PERIOD_AMOUNT50
, PERIOD_AMOUNT51 PERIOD_AMOUNT51
, PERIOD_AMOUNT52 PERIOD_AMOUNT52
, 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
, PARENT_ASSIGNMENT_ID PARENT_ASSIGNMENT_ID
FROM "PA"."PA_PROJ_PERIODS_DENORM"