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

TABLE: PJI.PJI_FP_CUST_PJP0

Object Details
Object Name: PJI_FP_CUST_PJP0
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FP_CUST_PJP0
Subobject Name:
Status: VALID

This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes Partitioning column.
TXN_ACCUM_HEADER_ID NUMBER (15) Yes Transaction accum header
PROJECT_ID NUMBER (15) Yes Identifier for the project
PROJECT_ORG_ID NUMBER (15) Yes Identifier for the project operating unit
PROJECT_ORGANIZATION_ID NUMBER (15) Yes Identifier of the Project Organization
PROJECT_ELEMENT_ID NUMBER (15) Yes This is the WBS element id and consists of projects and tasks.
TIME_ID NUMBER (15) Yes Numeric identifier for time
PERIOD_TYPE_ID NUMBER (15) Yes Numeric identifier for the period type (period, quarter, year, weeks)
CALENDAR_TYPE VARCHAR2 (1) Yes Specifies the calendar type (PA, GL, Enterprise)
RBS_AGGR_LEVEL VARCHAR2 (1) Yes Indicates, for the current task, the type of RBS aggregation.
WBS_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates, for the given project structure version, whether the amounts are rolled up by WBS or not.
PRG_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates whether the amounts are rolled up by Project Hierarchy or not.
CURR_RECORD_TYPE_ID NUMBER (15) Yes Identifier for the Currency record type
CURRENCY_CODE VARCHAR2 (30) Yes Currency Code
RBS_ELEMENT_ID NUMBER (15)
Identifier for the RBS
RBS_VERSION_ID NUMBER (15)
Identifier for the RBS version
PLAN_VERSION_ID NUMBER (15) Yes Same as Budget version identifier. >0 = version id, -1 = Actuals, -2 = Progress Actuals, -3 = Current Baselined, -4 = Current Original Baselined
PLAN_TYPE_ID NUMBER (15) Yes Identifier of the Plan Type
CUSTOM1 NUMBER

Custom measure1
CUSTOM2 NUMBER

Custom measure2
CUSTOM3 NUMBER

Custom measure3
CUSTOM4 NUMBER

Custom measure4
CUSTOM5 NUMBER

Custom measure5
CUSTOM6 NUMBER

Custom measure6
CUSTOM7 NUMBER

Custom measure7
CUSTOM8 NUMBER

Custom measure8
CUSTOM9 NUMBER

Custom measure9
CUSTOM10 NUMBER

Custom measure10
CUSTOM11 NUMBER

Custom measure11
CUSTOM12 NUMBER

Custom measure12
CUSTOM13 NUMBER

Custom measure13
CUSTOM14 NUMBER

Custom measure14
CUSTOM15 NUMBER

Custom measure15
Query Text

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


SELECT WORKER_ID
,      TXN_ACCUM_HEADER_ID
,      PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ELEMENT_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      RBS_AGGR_LEVEL
,      WBS_ROLLUP_FLAG
,      PRG_ROLLUP_FLAG
,      CURR_RECORD_TYPE_ID
,      CURRENCY_CODE
,      RBS_ELEMENT_ID
,      RBS_VERSION_ID
,      PLAN_VERSION_ID
,      PLAN_TYPE_ID
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
,      CUSTOM4
,      CUSTOM5
,      CUSTOM6
,      CUSTOM7
,      CUSTOM8
,      CUSTOM9
,      CUSTOM10
,      CUSTOM11
,      CUSTOM12
,      CUSTOM13
,      CUSTOM14
,      CUSTOM15
FROM PJI.PJI_FP_CUST_PJP0;

Dependencies

[top of page]

PJI.PJI_FP_CUST_PJP0 does not reference any database object

PJI.PJI_FP_CUST_PJP0 is referenced by following:

SchemaAPPS
SynonymPJI_FP_CUST_PJP0