eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_PROJ_PERIOD_PROFILES#

Source

View Text - Preformatted


select PERIOD_PROFILE_ID PERIOD_PROFILE_ID, PERIOD_PROFILE_TYPE PERIOD_PROFILE_TYPE, PROJECT_ID PROJECT_ID, PERIOD_SET_NAME PERIOD_SET_NAME, GL_PERIOD_TYPE GL_PERIOD_TYPE, PLAN_PERIOD_TYPE PLAN_PERIOD_TYPE, NUMBER_OF_PERIODS NUMBER_OF_PERIODS, PERIOD_NAME1 PERIOD_NAME1, PERIOD_NAME2 PERIOD_NAME2, PERIOD_NAME3 PERIOD_NAME3, PERIOD_NAME4 PERIOD_NAME4, PERIOD_NAME5 PERIOD_NAME5, PERIOD_NAME6 PERIOD_NAME6, PERIOD_NAME7 PERIOD_NAME7, PERIOD_NAME8 PERIOD_NAME8, PERIOD_NAME9 PERIOD_NAME9, PERIOD_NAME10 PERIOD_NAME10, PERIOD_NAME11 PERIOD_NAME11, PERIOD_NAME12 PERIOD_NAME12, PERIOD_NAME13 PERIOD_NAME13, PERIOD_NAME14 PERIOD_NAME14, PERIOD_NAME15 PERIOD_NAME15, PERIOD_NAME16 PERIOD_NAME16, PERIOD_NAME17 PERIOD_NAME17, PERIOD_NAME18 PERIOD_NAME18, PERIOD_NAME19 PERIOD_NAME19, PERIOD_NAME20 PERIOD_NAME20, PERIOD_NAME21 PERIOD_NAME21, PERIOD_NAME22 PERIOD_NAME22, PERIOD_NAME23 PERIOD_NAME23, PERIOD_NAME24 PERIOD_NAME24, PERIOD_NAME25 PERIOD_NAME25, PERIOD_NAME26 PERIOD_NAME26, PERIOD_NAME27 PERIOD_NAME27, PERIOD_NAME28 PERIOD_NAME28, PERIOD_NAME29 PERIOD_NAME29, PERIOD_NAME30 PERIOD_NAME30, PERIOD_NAME31 PERIOD_NAME31, PERIOD_NAME32 PERIOD_NAME32, PERIOD_NAME33 PERIOD_NAME33, PERIOD_NAME34 PERIOD_NAME34, PERIOD_NAME35 PERIOD_NAME35, PERIOD_NAME36 PERIOD_NAME36, PERIOD_NAME37 PERIOD_NAME37, PERIOD_NAME38 PERIOD_NAME38, PERIOD_NAME39 PERIOD_NAME39, PERIOD_NAME40 PERIOD_NAME40, PERIOD_NAME41 PERIOD_NAME41, PERIOD_NAME42 PERIOD_NAME42, PERIOD_NAME43 PERIOD_NAME43, PERIOD_NAME44 PERIOD_NAME44, PERIOD_NAME45 PERIOD_NAME45, PERIOD_NAME46 PERIOD_NAME46, PERIOD_NAME47 PERIOD_NAME47, PERIOD_NAME48 PERIOD_NAME48, PERIOD_NAME49 PERIOD_NAME49, PERIOD_NAME50 PERIOD_NAME50, PERIOD_NAME51 PERIOD_NAME51, PERIOD_NAME52 PERIOD_NAME52, PERIOD1_START_DATE PERIOD1_START_DATE, PERIOD2_START_DATE PERIOD2_START_DATE, PERIOD3_START_DATE PERIOD3_START_DATE, PERIOD4_START_DATE PERIOD4_START_DATE, PERIOD5_START_DATE PERIOD5_START_DATE, PERIOD6_START_DATE PERIOD6_START_DATE, PERIOD7_START_DATE PERIOD7_START_DATE, PERIOD8_START_DATE PERIOD8_START_DATE, PERIOD9_START_DATE PERIOD9_START_DATE, PERIOD10_START_DATE PERIOD10_START_DATE, PERIOD11_START_DATE PERIOD11_START_DATE, PERIOD12_START_DATE PERIOD12_START_DATE, PERIOD13_START_DATE PERIOD13_START_DATE, PERIOD14_START_DATE PERIOD14_START_DATE, PERIOD15_START_DATE PERIOD15_START_DATE, PERIOD16_START_DATE PERIOD16_START_DATE, PERIOD17_START_DATE PERIOD17_START_DATE, PERIOD18_START_DATE PERIOD18_START_DATE, PERIOD19_START_DATE PERIOD19_START_DATE, PERIOD20_START_DATE PERIOD20_START_DATE, PERIOD21_START_DATE PERIOD21_START_DATE, PERIOD22_START_DATE PERIOD22_START_DATE, PERIOD23_START_DATE PERIOD23_START_DATE, PERIOD24_START_DATE PERIOD24_START_DATE, PERIOD25_START_DATE PERIOD25_START_DATE, PERIOD26_START_DATE PERIOD26_START_DATE, PERIOD27_START_DATE PERIOD27_START_DATE, PERIOD28_START_DATE PERIOD28_START_DATE, PERIOD29_START_DATE PERIOD29_START_DATE, PERIOD30_START_DATE PERIOD30_START_DATE, PERIOD31_START_DATE PERIOD31_START_DATE, PERIOD32_START_DATE PERIOD32_START_DATE, PERIOD33_START_DATE PERIOD33_START_DATE, PERIOD34_START_DATE PERIOD34_START_DATE, PERIOD35_START_DATE PERIOD35_START_DATE, PERIOD36_START_DATE PERIOD36_START_DATE, PERIOD37_START_DATE PERIOD37_START_DATE, PERIOD38_START_DATE PERIOD38_START_DATE, PERIOD39_START_DATE PERIOD39_START_DATE, PERIOD40_START_DATE PERIOD40_START_DATE, PERIOD41_START_DATE PERIOD41_START_DATE, PERIOD42_START_DATE PERIOD42_START_DATE, PERIOD43_START_DATE PERIOD43_START_DATE, PERIOD44_START_DATE PERIOD44_START_DATE, PERIOD45_START_DATE PERIOD45_START_DATE, PERIOD46_START_DATE PERIOD46_START_DATE, PERIOD47_START_DATE PERIOD47_START_DATE, PERIOD48_START_DATE PERIOD48_START_DATE, PERIOD49_START_DATE PERIOD49_START_DATE, PERIOD50_START_DATE PERIOD50_START_DATE, PERIOD51_START_DATE PERIOD51_START_DATE, PERIOD52_START_DATE PERIOD52_START_DATE, PERIOD1_END_DATE PERIOD1_END_DATE, PERIOD2_END_DATE PERIOD2_END_DATE, PERIOD3_END_DATE PERIOD3_END_DATE, PERIOD4_END_DATE PERIOD4_END_DATE, PERIOD5_END_DATE PERIOD5_END_DATE, PERIOD6_END_DATE PERIOD6_END_DATE, PERIOD7_END_DATE PERIOD7_END_DATE, PERIOD8_END_DATE PERIOD8_END_DATE, PERIOD9_END_DATE PERIOD9_END_DATE, PERIOD10_END_DATE PERIOD10_END_DATE, PERIOD11_END_DATE PERIOD11_END_DATE, PERIOD12_END_DATE PERIOD12_END_DATE, PERIOD13_END_DATE PERIOD13_END_DATE, PERIOD14_END_DATE PERIOD14_END_DATE, PERIOD15_END_DATE PERIOD15_END_DATE, PERIOD16_END_DATE PERIOD16_END_DATE, PERIOD17_END_DATE PERIOD17_END_DATE, PERIOD18_END_DATE PERIOD18_END_DATE, PERIOD19_END_DATE PERIOD19_END_DATE, PERIOD20_END_DATE PERIOD20_END_DATE, PERIOD21_END_DATE PERIOD21_END_DATE, PERIOD22_END_DATE PERIOD22_END_DATE, PERIOD23_END_DATE PERIOD23_END_DATE, PERIOD24_END_DATE PERIOD24_END_DATE, PERIOD25_END_DATE PERIOD25_END_DATE, PERIOD26_END_DATE PERIOD26_END_DATE, PERIOD27_END_DATE PERIOD27_END_DATE, PERIOD28_END_DATE PERIOD28_END_DATE, PERIOD29_END_DATE PERIOD29_END_DATE, PERIOD30_END_DATE PERIOD30_END_DATE, PERIOD31_END_DATE PERIOD31_END_DATE, PERIOD32_END_DATE PERIOD32_END_DATE, PERIOD33_END_DATE PERIOD33_END_DATE, PERIOD34_END_DATE PERIOD34_END_DATE, PERIOD35_END_DATE PERIOD35_END_DATE, PERIOD36_END_DATE PERIOD36_END_DATE, PERIOD37_END_DATE PERIOD37_END_DATE, PERIOD38_END_DATE PERIOD38_END_DATE, PERIOD39_END_DATE PERIOD39_END_DATE, PERIOD40_END_DATE PERIOD40_END_DATE, PERIOD41_END_DATE PERIOD41_END_DATE, PERIOD42_END_DATE PERIOD42_END_DATE, PERIOD43_END_DATE PERIOD43_END_DATE, PERIOD44_END_DATE PERIOD44_END_DATE, PERIOD45_END_DATE PERIOD45_END_DATE, PERIOD46_END_DATE PERIOD46_END_DATE, PERIOD47_END_DATE PERIOD47_END_DATE, PERIOD48_END_DATE PERIOD48_END_DATE, PERIOD49_END_DATE PERIOD49_END_DATE, PERIOD50_END_DATE PERIOD50_END_DATE, PERIOD51_END_DATE PERIOD51_END_DATE, PERIOD52_END_DATE PERIOD52_END_DATE, 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, CURRENT_FLAG CURRENT_FLAG, PROFILE_END_PERIOD_NAME PROFILE_END_PERIOD_NAME from "PA"."PA_PROJ_PERIOD_PROFILES"

View Text - HTML Formatted

SELECT PERIOD_PROFILE_ID PERIOD_PROFILE_ID
, PERIOD_PROFILE_TYPE PERIOD_PROFILE_TYPE
, PROJECT_ID PROJECT_ID
, PERIOD_SET_NAME PERIOD_SET_NAME
, GL_PERIOD_TYPE GL_PERIOD_TYPE
, PLAN_PERIOD_TYPE PLAN_PERIOD_TYPE
, NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, PERIOD_NAME1 PERIOD_NAME1
, PERIOD_NAME2 PERIOD_NAME2
, PERIOD_NAME3 PERIOD_NAME3
, PERIOD_NAME4 PERIOD_NAME4
, PERIOD_NAME5 PERIOD_NAME5
, PERIOD_NAME6 PERIOD_NAME6
, PERIOD_NAME7 PERIOD_NAME7
, PERIOD_NAME8 PERIOD_NAME8
, PERIOD_NAME9 PERIOD_NAME9
, PERIOD_NAME10 PERIOD_NAME10
, PERIOD_NAME11 PERIOD_NAME11
, PERIOD_NAME12 PERIOD_NAME12
, PERIOD_NAME13 PERIOD_NAME13
, PERIOD_NAME14 PERIOD_NAME14
, PERIOD_NAME15 PERIOD_NAME15
, PERIOD_NAME16 PERIOD_NAME16
, PERIOD_NAME17 PERIOD_NAME17
, PERIOD_NAME18 PERIOD_NAME18
, PERIOD_NAME19 PERIOD_NAME19
, PERIOD_NAME20 PERIOD_NAME20
, PERIOD_NAME21 PERIOD_NAME21
, PERIOD_NAME22 PERIOD_NAME22
, PERIOD_NAME23 PERIOD_NAME23
, PERIOD_NAME24 PERIOD_NAME24
, PERIOD_NAME25 PERIOD_NAME25
, PERIOD_NAME26 PERIOD_NAME26
, PERIOD_NAME27 PERIOD_NAME27
, PERIOD_NAME28 PERIOD_NAME28
, PERIOD_NAME29 PERIOD_NAME29
, PERIOD_NAME30 PERIOD_NAME30
, PERIOD_NAME31 PERIOD_NAME31
, PERIOD_NAME32 PERIOD_NAME32
, PERIOD_NAME33 PERIOD_NAME33
, PERIOD_NAME34 PERIOD_NAME34
, PERIOD_NAME35 PERIOD_NAME35
, PERIOD_NAME36 PERIOD_NAME36
, PERIOD_NAME37 PERIOD_NAME37
, PERIOD_NAME38 PERIOD_NAME38
, PERIOD_NAME39 PERIOD_NAME39
, PERIOD_NAME40 PERIOD_NAME40
, PERIOD_NAME41 PERIOD_NAME41
, PERIOD_NAME42 PERIOD_NAME42
, PERIOD_NAME43 PERIOD_NAME43
, PERIOD_NAME44 PERIOD_NAME44
, PERIOD_NAME45 PERIOD_NAME45
, PERIOD_NAME46 PERIOD_NAME46
, PERIOD_NAME47 PERIOD_NAME47
, PERIOD_NAME48 PERIOD_NAME48
, PERIOD_NAME49 PERIOD_NAME49
, PERIOD_NAME50 PERIOD_NAME50
, PERIOD_NAME51 PERIOD_NAME51
, PERIOD_NAME52 PERIOD_NAME52
, PERIOD1_START_DATE PERIOD1_START_DATE
, PERIOD2_START_DATE PERIOD2_START_DATE
, PERIOD3_START_DATE PERIOD3_START_DATE
, PERIOD4_START_DATE PERIOD4_START_DATE
, PERIOD5_START_DATE PERIOD5_START_DATE
, PERIOD6_START_DATE PERIOD6_START_DATE
, PERIOD7_START_DATE PERIOD7_START_DATE
, PERIOD8_START_DATE PERIOD8_START_DATE
, PERIOD9_START_DATE PERIOD9_START_DATE
, PERIOD10_START_DATE PERIOD10_START_DATE
, PERIOD11_START_DATE PERIOD11_START_DATE
, PERIOD12_START_DATE PERIOD12_START_DATE
, PERIOD13_START_DATE PERIOD13_START_DATE
, PERIOD14_START_DATE PERIOD14_START_DATE
, PERIOD15_START_DATE PERIOD15_START_DATE
, PERIOD16_START_DATE PERIOD16_START_DATE
, PERIOD17_START_DATE PERIOD17_START_DATE
, PERIOD18_START_DATE PERIOD18_START_DATE
, PERIOD19_START_DATE PERIOD19_START_DATE
, PERIOD20_START_DATE PERIOD20_START_DATE
, PERIOD21_START_DATE PERIOD21_START_DATE
, PERIOD22_START_DATE PERIOD22_START_DATE
, PERIOD23_START_DATE PERIOD23_START_DATE
, PERIOD24_START_DATE PERIOD24_START_DATE
, PERIOD25_START_DATE PERIOD25_START_DATE
, PERIOD26_START_DATE PERIOD26_START_DATE
, PERIOD27_START_DATE PERIOD27_START_DATE
, PERIOD28_START_DATE PERIOD28_START_DATE
, PERIOD29_START_DATE PERIOD29_START_DATE
, PERIOD30_START_DATE PERIOD30_START_DATE
, PERIOD31_START_DATE PERIOD31_START_DATE
, PERIOD32_START_DATE PERIOD32_START_DATE
, PERIOD33_START_DATE PERIOD33_START_DATE
, PERIOD34_START_DATE PERIOD34_START_DATE
, PERIOD35_START_DATE PERIOD35_START_DATE
, PERIOD36_START_DATE PERIOD36_START_DATE
, PERIOD37_START_DATE PERIOD37_START_DATE
, PERIOD38_START_DATE PERIOD38_START_DATE
, PERIOD39_START_DATE PERIOD39_START_DATE
, PERIOD40_START_DATE PERIOD40_START_DATE
, PERIOD41_START_DATE PERIOD41_START_DATE
, PERIOD42_START_DATE PERIOD42_START_DATE
, PERIOD43_START_DATE PERIOD43_START_DATE
, PERIOD44_START_DATE PERIOD44_START_DATE
, PERIOD45_START_DATE PERIOD45_START_DATE
, PERIOD46_START_DATE PERIOD46_START_DATE
, PERIOD47_START_DATE PERIOD47_START_DATE
, PERIOD48_START_DATE PERIOD48_START_DATE
, PERIOD49_START_DATE PERIOD49_START_DATE
, PERIOD50_START_DATE PERIOD50_START_DATE
, PERIOD51_START_DATE PERIOD51_START_DATE
, PERIOD52_START_DATE PERIOD52_START_DATE
, PERIOD1_END_DATE PERIOD1_END_DATE
, PERIOD2_END_DATE PERIOD2_END_DATE
, PERIOD3_END_DATE PERIOD3_END_DATE
, PERIOD4_END_DATE PERIOD4_END_DATE
, PERIOD5_END_DATE PERIOD5_END_DATE
, PERIOD6_END_DATE PERIOD6_END_DATE
, PERIOD7_END_DATE PERIOD7_END_DATE
, PERIOD8_END_DATE PERIOD8_END_DATE
, PERIOD9_END_DATE PERIOD9_END_DATE
, PERIOD10_END_DATE PERIOD10_END_DATE
, PERIOD11_END_DATE PERIOD11_END_DATE
, PERIOD12_END_DATE PERIOD12_END_DATE
, PERIOD13_END_DATE PERIOD13_END_DATE
, PERIOD14_END_DATE PERIOD14_END_DATE
, PERIOD15_END_DATE PERIOD15_END_DATE
, PERIOD16_END_DATE PERIOD16_END_DATE
, PERIOD17_END_DATE PERIOD17_END_DATE
, PERIOD18_END_DATE PERIOD18_END_DATE
, PERIOD19_END_DATE PERIOD19_END_DATE
, PERIOD20_END_DATE PERIOD20_END_DATE
, PERIOD21_END_DATE PERIOD21_END_DATE
, PERIOD22_END_DATE PERIOD22_END_DATE
, PERIOD23_END_DATE PERIOD23_END_DATE
, PERIOD24_END_DATE PERIOD24_END_DATE
, PERIOD25_END_DATE PERIOD25_END_DATE
, PERIOD26_END_DATE PERIOD26_END_DATE
, PERIOD27_END_DATE PERIOD27_END_DATE
, PERIOD28_END_DATE PERIOD28_END_DATE
, PERIOD29_END_DATE PERIOD29_END_DATE
, PERIOD30_END_DATE PERIOD30_END_DATE
, PERIOD31_END_DATE PERIOD31_END_DATE
, PERIOD32_END_DATE PERIOD32_END_DATE
, PERIOD33_END_DATE PERIOD33_END_DATE
, PERIOD34_END_DATE PERIOD34_END_DATE
, PERIOD35_END_DATE PERIOD35_END_DATE
, PERIOD36_END_DATE PERIOD36_END_DATE
, PERIOD37_END_DATE PERIOD37_END_DATE
, PERIOD38_END_DATE PERIOD38_END_DATE
, PERIOD39_END_DATE PERIOD39_END_DATE
, PERIOD40_END_DATE PERIOD40_END_DATE
, PERIOD41_END_DATE PERIOD41_END_DATE
, PERIOD42_END_DATE PERIOD42_END_DATE
, PERIOD43_END_DATE PERIOD43_END_DATE
, PERIOD44_END_DATE PERIOD44_END_DATE
, PERIOD45_END_DATE PERIOD45_END_DATE
, PERIOD46_END_DATE PERIOD46_END_DATE
, PERIOD47_END_DATE PERIOD47_END_DATE
, PERIOD48_END_DATE PERIOD48_END_DATE
, PERIOD49_END_DATE PERIOD49_END_DATE
, PERIOD50_END_DATE PERIOD50_END_DATE
, PERIOD51_END_DATE PERIOD51_END_DATE
, PERIOD52_END_DATE PERIOD52_END_DATE
, 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
, CURRENT_FLAG CURRENT_FLAG
, PROFILE_END_PERIOD_NAME PROFILE_END_PERIOD_NAME
FROM "PA"."PA_PROJ_PERIOD_PROFILES"