Skip to content

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

VIEW: PA.PA_PROJ_PERIODS_DENORM#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_VERSION_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
RESOURCE_ASSIGNMENT_ID NUMBER (15) Yes
OBJECT_ID NUMBER (15) Yes
OBJECT_TYPE_CODE VARCHAR2 (30) Yes
PERIOD_PROFILE_ID NUMBER (15) Yes
AMOUNT_TYPE_CODE VARCHAR2 (30) Yes
AMOUNT_SUBTYPE_CODE VARCHAR2 (30) Yes
AMOUNT_TYPE_ID NUMBER (15) Yes
AMOUNT_SUBTYPE_ID NUMBER (15) Yes
CURRENCY_TYPE VARCHAR2 (30) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
PRECEDING_PERIODS_AMOUNT NUMBER

SUCCEEDING_PERIODS_AMOUNT NUMBER

PRIOR_PERIOD_AMOUNT NUMBER

PERIOD_AMOUNT1 NUMBER

PERIOD_AMOUNT2 NUMBER

PERIOD_AMOUNT3 NUMBER

PERIOD_AMOUNT4 NUMBER

PERIOD_AMOUNT5 NUMBER

PERIOD_AMOUNT6 NUMBER

PERIOD_AMOUNT7 NUMBER

PERIOD_AMOUNT8 NUMBER

PERIOD_AMOUNT9 NUMBER

PERIOD_AMOUNT10 NUMBER

PERIOD_AMOUNT11 NUMBER

PERIOD_AMOUNT12 NUMBER

PERIOD_AMOUNT13 NUMBER

PERIOD_AMOUNT14 NUMBER

PERIOD_AMOUNT15 NUMBER

PERIOD_AMOUNT16 NUMBER

PERIOD_AMOUNT17 NUMBER

PERIOD_AMOUNT18 NUMBER

PERIOD_AMOUNT19 NUMBER

PERIOD_AMOUNT20 NUMBER

PERIOD_AMOUNT21 NUMBER

PERIOD_AMOUNT22 NUMBER

PERIOD_AMOUNT23 NUMBER

PERIOD_AMOUNT24 NUMBER

PERIOD_AMOUNT25 NUMBER

PERIOD_AMOUNT26 NUMBER

PERIOD_AMOUNT27 NUMBER

PERIOD_AMOUNT28 NUMBER

PERIOD_AMOUNT29 NUMBER

PERIOD_AMOUNT30 NUMBER

PERIOD_AMOUNT31 NUMBER

PERIOD_AMOUNT32 NUMBER

PERIOD_AMOUNT33 NUMBER

PERIOD_AMOUNT34 NUMBER

PERIOD_AMOUNT35 NUMBER

PERIOD_AMOUNT36 NUMBER

PERIOD_AMOUNT37 NUMBER

PERIOD_AMOUNT38 NUMBER

PERIOD_AMOUNT39 NUMBER

PERIOD_AMOUNT40 NUMBER

PERIOD_AMOUNT41 NUMBER

PERIOD_AMOUNT42 NUMBER

PERIOD_AMOUNT43 NUMBER

PERIOD_AMOUNT44 NUMBER

PERIOD_AMOUNT45 NUMBER

PERIOD_AMOUNT46 NUMBER

PERIOD_AMOUNT47 NUMBER

PERIOD_AMOUNT48 NUMBER

PERIOD_AMOUNT49 NUMBER

PERIOD_AMOUNT50 NUMBER

PERIOD_AMOUNT51 NUMBER

PERIOD_AMOUNT52 NUMBER

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
PARENT_ASSIGNMENT_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

PA.PA_PROJ_PERIODS_DENORM# references the following:

SchemaPA
TablePA_PROJ_PERIODS_DENORM
PA.PA_PROJ_PERIODS_DENORM# is referenced by following:

SchemaAPPS
SynonymPA_PROJ_PERIODS_DENORM