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

TABLE: PJI.PJI_RM_AGGR_RES6

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


This intermediate table contains data to be loaded into PJI_RM_AGGR_RES1 when PJI RM summarization is run


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes Summarization state data
TOTAL_HRS_A NUMBER

Actual hours
BILL_HRS_A NUMBER

Billable actual hours
PERIOD_TYPE_ID NUMBER
Yes Calendar rollup level
CALENDAR_TYPE VARCHAR2 (1) Yes Common, GL, PA or Enterprise calendar
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Yes Expenditure Organization
EXPENDITURE_ORG_ID NUMBER (15) Yes Expenditure Operating Unit
TIME_ID NUMBER (15) Yes Transaction date
PERSON_ID NUMBER (15) Yes Identifier for the Person
JOB_ID NUMBER (15) Yes Identifier for the Job
PROJECT_ID NUMBER (15) Yes Identifier for the Project
WORK_TYPE_ID NUMBER (15) Yes Identifier for the Work Type
GL_CALENDAR_ID NUMBER (15)
GL Calendar lookup
PA_CALENDAR_ID NUMBER (15)
PA Calendar lookup
Query Text

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


SELECT WORKER_ID
,      TOTAL_HRS_A
,      BILL_HRS_A
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG_ID
,      TIME_ID
,      PERSON_ID
,      JOB_ID
,      PROJECT_ID
,      WORK_TYPE_ID
,      GL_CALENDAR_ID
,      PA_CALENDAR_ID
FROM PJI.PJI_RM_AGGR_RES6;

Dependencies

[top of page]

PJI.PJI_RM_AGGR_RES6 does not reference any database object

PJI.PJI_RM_AGGR_RES6 is referenced by following:

SchemaPJI
ViewPJI_RM_AGGR_RES6#