[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_PERIOD_PROFILES# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_PROFILE_ID | NUMBER | (15) | Yes | |
PERIOD_PROFILE_TYPE | VARCHAR2 | (30) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | |
GL_PERIOD_TYPE | VARCHAR2 | (15) | Yes | |
PLAN_PERIOD_TYPE | VARCHAR2 | (30) | Yes | |
NUMBER_OF_PERIODS | NUMBER | (15) | ||
PERIOD_NAME1 | VARCHAR2 | (30) | ||
PERIOD_NAME2 | VARCHAR2 | (30) | ||
PERIOD_NAME3 | VARCHAR2 | (30) | ||
PERIOD_NAME4 | VARCHAR2 | (30) | ||
PERIOD_NAME5 | VARCHAR2 | (30) | ||
PERIOD_NAME6 | VARCHAR2 | (30) | ||
PERIOD_NAME7 | VARCHAR2 | (30) | ||
PERIOD_NAME8 | VARCHAR2 | (30) | ||
PERIOD_NAME9 | VARCHAR2 | (30) | ||
PERIOD_NAME10 | VARCHAR2 | (30) | ||
PERIOD_NAME11 | VARCHAR2 | (30) | ||
PERIOD_NAME12 | VARCHAR2 | (30) | ||
PERIOD_NAME13 | VARCHAR2 | (30) | ||
PERIOD_NAME14 | VARCHAR2 | (30) | ||
PERIOD_NAME15 | VARCHAR2 | (30) | ||
PERIOD_NAME16 | VARCHAR2 | (30) | ||
PERIOD_NAME17 | VARCHAR2 | (30) | ||
PERIOD_NAME18 | VARCHAR2 | (30) | ||
PERIOD_NAME19 | VARCHAR2 | (30) | ||
PERIOD_NAME20 | VARCHAR2 | (30) | ||
PERIOD_NAME21 | VARCHAR2 | (30) | ||
PERIOD_NAME22 | VARCHAR2 | (30) | ||
PERIOD_NAME23 | VARCHAR2 | (30) | ||
PERIOD_NAME24 | VARCHAR2 | (30) | ||
PERIOD_NAME25 | VARCHAR2 | (30) | ||
PERIOD_NAME26 | VARCHAR2 | (30) | ||
PERIOD_NAME27 | VARCHAR2 | (30) | ||
PERIOD_NAME28 | VARCHAR2 | (30) | ||
PERIOD_NAME29 | VARCHAR2 | (30) | ||
PERIOD_NAME30 | VARCHAR2 | (30) | ||
PERIOD_NAME31 | VARCHAR2 | (30) | ||
PERIOD_NAME32 | VARCHAR2 | (30) | ||
PERIOD_NAME33 | VARCHAR2 | (30) | ||
PERIOD_NAME34 | VARCHAR2 | (30) | ||
PERIOD_NAME35 | VARCHAR2 | (30) | ||
PERIOD_NAME36 | VARCHAR2 | (30) | ||
PERIOD_NAME37 | VARCHAR2 | (30) | ||
PERIOD_NAME38 | VARCHAR2 | (30) | ||
PERIOD_NAME39 | VARCHAR2 | (30) | ||
PERIOD_NAME40 | VARCHAR2 | (30) | ||
PERIOD_NAME41 | VARCHAR2 | (30) | ||
PERIOD_NAME42 | VARCHAR2 | (30) | ||
PERIOD_NAME43 | VARCHAR2 | (30) | ||
PERIOD_NAME44 | VARCHAR2 | (30) | ||
PERIOD_NAME45 | VARCHAR2 | (30) | ||
PERIOD_NAME46 | VARCHAR2 | (30) | ||
PERIOD_NAME47 | VARCHAR2 | (30) | ||
PERIOD_NAME48 | VARCHAR2 | (30) | ||
PERIOD_NAME49 | VARCHAR2 | (30) | ||
PERIOD_NAME50 | VARCHAR2 | (30) | ||
PERIOD_NAME51 | VARCHAR2 | (30) | ||
PERIOD_NAME52 | VARCHAR2 | (30) | ||
PERIOD1_START_DATE | DATE | |||
PERIOD2_START_DATE | DATE | |||
PERIOD3_START_DATE | DATE | |||
PERIOD4_START_DATE | DATE | |||
PERIOD5_START_DATE | DATE | |||
PERIOD6_START_DATE | DATE | |||
PERIOD7_START_DATE | DATE | |||
PERIOD8_START_DATE | DATE | |||
PERIOD9_START_DATE | DATE | |||
PERIOD10_START_DATE | DATE | |||
PERIOD11_START_DATE | DATE | |||
PERIOD12_START_DATE | DATE | |||
PERIOD13_START_DATE | DATE | |||
PERIOD14_START_DATE | DATE | |||
PERIOD15_START_DATE | DATE | |||
PERIOD16_START_DATE | DATE | |||
PERIOD17_START_DATE | DATE | |||
PERIOD18_START_DATE | DATE | |||
PERIOD19_START_DATE | DATE | |||
PERIOD20_START_DATE | DATE | |||
PERIOD21_START_DATE | DATE | |||
PERIOD22_START_DATE | DATE | |||
PERIOD23_START_DATE | DATE | |||
PERIOD24_START_DATE | DATE | |||
PERIOD25_START_DATE | DATE | |||
PERIOD26_START_DATE | DATE | |||
PERIOD27_START_DATE | DATE | |||
PERIOD28_START_DATE | DATE | |||
PERIOD29_START_DATE | DATE | |||
PERIOD30_START_DATE | DATE | |||
PERIOD31_START_DATE | DATE | |||
PERIOD32_START_DATE | DATE | |||
PERIOD33_START_DATE | DATE | |||
PERIOD34_START_DATE | DATE | |||
PERIOD35_START_DATE | DATE | |||
PERIOD36_START_DATE | DATE | |||
PERIOD37_START_DATE | DATE | |||
PERIOD38_START_DATE | DATE | |||
PERIOD39_START_DATE | DATE | |||
PERIOD40_START_DATE | DATE | |||
PERIOD41_START_DATE | DATE | |||
PERIOD42_START_DATE | DATE | |||
PERIOD43_START_DATE | DATE | |||
PERIOD44_START_DATE | DATE | |||
PERIOD45_START_DATE | DATE | |||
PERIOD46_START_DATE | DATE | |||
PERIOD47_START_DATE | DATE | |||
PERIOD48_START_DATE | DATE | |||
PERIOD49_START_DATE | DATE | |||
PERIOD50_START_DATE | DATE | |||
PERIOD51_START_DATE | DATE | |||
PERIOD52_START_DATE | DATE | |||
PERIOD1_END_DATE | DATE | |||
PERIOD2_END_DATE | DATE | |||
PERIOD3_END_DATE | DATE | |||
PERIOD4_END_DATE | DATE | |||
PERIOD5_END_DATE | DATE | |||
PERIOD6_END_DATE | DATE | |||
PERIOD7_END_DATE | DATE | |||
PERIOD8_END_DATE | DATE | |||
PERIOD9_END_DATE | DATE | |||
PERIOD10_END_DATE | DATE | |||
PERIOD11_END_DATE | DATE | |||
PERIOD12_END_DATE | DATE | |||
PERIOD13_END_DATE | DATE | |||
PERIOD14_END_DATE | DATE | |||
PERIOD15_END_DATE | DATE | |||
PERIOD16_END_DATE | DATE | |||
PERIOD17_END_DATE | DATE | |||
PERIOD18_END_DATE | DATE | |||
PERIOD19_END_DATE | DATE | |||
PERIOD20_END_DATE | DATE | |||
PERIOD21_END_DATE | DATE | |||
PERIOD22_END_DATE | DATE | |||
PERIOD23_END_DATE | DATE | |||
PERIOD24_END_DATE | DATE | |||
PERIOD25_END_DATE | DATE | |||
PERIOD26_END_DATE | DATE | |||
PERIOD27_END_DATE | DATE | |||
PERIOD28_END_DATE | DATE | |||
PERIOD29_END_DATE | DATE | |||
PERIOD30_END_DATE | DATE | |||
PERIOD31_END_DATE | DATE | |||
PERIOD32_END_DATE | DATE | |||
PERIOD33_END_DATE | DATE | |||
PERIOD34_END_DATE | DATE | |||
PERIOD35_END_DATE | DATE | |||
PERIOD36_END_DATE | DATE | |||
PERIOD37_END_DATE | DATE | |||
PERIOD38_END_DATE | DATE | |||
PERIOD39_END_DATE | DATE | |||
PERIOD40_END_DATE | DATE | |||
PERIOD41_END_DATE | DATE | |||
PERIOD42_END_DATE | DATE | |||
PERIOD43_END_DATE | DATE | |||
PERIOD44_END_DATE | DATE | |||
PERIOD45_END_DATE | DATE | |||
PERIOD46_END_DATE | DATE | |||
PERIOD47_END_DATE | DATE | |||
PERIOD48_END_DATE | DATE | |||
PERIOD49_END_DATE | DATE | |||
PERIOD50_END_DATE | DATE | |||
PERIOD51_END_DATE | DATE | |||
PERIOD52_END_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
CURRENT_FLAG | VARCHAR2 | (1) | ||
PROFILE_END_PERIOD_NAME | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_PROFILE_ID
, PERIOD_PROFILE_TYPE
, PROJECT_ID
, PERIOD_SET_NAME
, GL_PERIOD_TYPE
, PLAN_PERIOD_TYPE
, NUMBER_OF_PERIODS
, PERIOD_NAME1
, PERIOD_NAME2
, PERIOD_NAME3
, PERIOD_NAME4
, PERIOD_NAME5
, PERIOD_NAME6
, PERIOD_NAME7
, PERIOD_NAME8
, PERIOD_NAME9
, PERIOD_NAME10
, PERIOD_NAME11
, PERIOD_NAME12
, PERIOD_NAME13
, PERIOD_NAME14
, PERIOD_NAME15
, PERIOD_NAME16
, PERIOD_NAME17
, PERIOD_NAME18
, PERIOD_NAME19
, PERIOD_NAME20
, PERIOD_NAME21
, PERIOD_NAME22
, PERIOD_NAME23
, PERIOD_NAME24
, PERIOD_NAME25
, PERIOD_NAME26
, PERIOD_NAME27
, PERIOD_NAME28
, PERIOD_NAME29
, PERIOD_NAME30
, PERIOD_NAME31
, PERIOD_NAME32
, PERIOD_NAME33
, PERIOD_NAME34
, PERIOD_NAME35
, PERIOD_NAME36
, PERIOD_NAME37
, PERIOD_NAME38
, PERIOD_NAME39
, PERIOD_NAME40
, PERIOD_NAME41
, PERIOD_NAME42
, PERIOD_NAME43
, PERIOD_NAME44
, PERIOD_NAME45
, PERIOD_NAME46
, PERIOD_NAME47
, PERIOD_NAME48
, PERIOD_NAME49
, PERIOD_NAME50
, PERIOD_NAME51
, PERIOD_NAME52
, PERIOD1_START_DATE
, PERIOD2_START_DATE
, PERIOD3_START_DATE
, PERIOD4_START_DATE
, PERIOD5_START_DATE
, PERIOD6_START_DATE
, PERIOD7_START_DATE
, PERIOD8_START_DATE
, PERIOD9_START_DATE
, PERIOD10_START_DATE
, PERIOD11_START_DATE
, PERIOD12_START_DATE
, PERIOD13_START_DATE
, PERIOD14_START_DATE
, PERIOD15_START_DATE
, PERIOD16_START_DATE
, PERIOD17_START_DATE
, PERIOD18_START_DATE
, PERIOD19_START_DATE
, PERIOD20_START_DATE
, PERIOD21_START_DATE
, PERIOD22_START_DATE
, PERIOD23_START_DATE
, PERIOD24_START_DATE
, PERIOD25_START_DATE
, PERIOD26_START_DATE
, PERIOD27_START_DATE
, PERIOD28_START_DATE
, PERIOD29_START_DATE
, PERIOD30_START_DATE
, PERIOD31_START_DATE
, PERIOD32_START_DATE
, PERIOD33_START_DATE
, PERIOD34_START_DATE
, PERIOD35_START_DATE
, PERIOD36_START_DATE
, PERIOD37_START_DATE
, PERIOD38_START_DATE
, PERIOD39_START_DATE
, PERIOD40_START_DATE
, PERIOD41_START_DATE
, PERIOD42_START_DATE
, PERIOD43_START_DATE
, PERIOD44_START_DATE
, PERIOD45_START_DATE
, PERIOD46_START_DATE
, PERIOD47_START_DATE
, PERIOD48_START_DATE
, PERIOD49_START_DATE
, PERIOD50_START_DATE
, PERIOD51_START_DATE
, PERIOD52_START_DATE
, PERIOD1_END_DATE
, PERIOD2_END_DATE
, PERIOD3_END_DATE
, PERIOD4_END_DATE
, PERIOD5_END_DATE
, PERIOD6_END_DATE
, PERIOD7_END_DATE
, PERIOD8_END_DATE
, PERIOD9_END_DATE
, PERIOD10_END_DATE
, PERIOD11_END_DATE
, PERIOD12_END_DATE
, PERIOD13_END_DATE
, PERIOD14_END_DATE
, PERIOD15_END_DATE
, PERIOD16_END_DATE
, PERIOD17_END_DATE
, PERIOD18_END_DATE
, PERIOD19_END_DATE
, PERIOD20_END_DATE
, PERIOD21_END_DATE
, PERIOD22_END_DATE
, PERIOD23_END_DATE
, PERIOD24_END_DATE
, PERIOD25_END_DATE
, PERIOD26_END_DATE
, PERIOD27_END_DATE
, PERIOD28_END_DATE
, PERIOD29_END_DATE
, PERIOD30_END_DATE
, PERIOD31_END_DATE
, PERIOD32_END_DATE
, PERIOD33_END_DATE
, PERIOD34_END_DATE
, PERIOD35_END_DATE
, PERIOD36_END_DATE
, PERIOD37_END_DATE
, PERIOD38_END_DATE
, PERIOD39_END_DATE
, PERIOD40_END_DATE
, PERIOD41_END_DATE
, PERIOD42_END_DATE
, PERIOD43_END_DATE
, PERIOD44_END_DATE
, PERIOD45_END_DATE
, PERIOD46_END_DATE
, PERIOD47_END_DATE
, PERIOD48_END_DATE
, PERIOD49_END_DATE
, PERIOD50_END_DATE
, PERIOD51_END_DATE
, PERIOD52_END_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CURRENT_FLAG
, PROFILE_END_PERIOD_NAME
FROM PA.PA_PROJ_PERIOD_PROFILES#;
|
|
|