DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_PROJ_PERIOD_PROFILES#

Object Details
Object Name: PA_PROJ_PERIOD_PROFILES#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

PA.PA_PROJ_PERIOD_PROFILES# references the following:

SchemaPA
TablePA_PROJ_PERIOD_PROFILES
PA.PA_PROJ_PERIOD_PROFILES# is referenced by following:

SchemaAPPS
SynonymPA_PROJ_PERIOD_PROFILES