Skip to content

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

VIEW: PJI.PJI_FP_AGGR_PJP2#

Object Details
Object Name: PJI_FP_AGGR_PJP2#
Object Type: VIEW
Owner: PJI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes
RECORD_TYPE VARCHAR2 (1)
PRG_LEVEL NUMBER (15)
PROJECT_ID NUMBER (15) Yes
PROJECT_ORG_ID NUMBER (15) Yes
PROJECT_ORGANIZATION_ID NUMBER (15) Yes
PROJECT_ELEMENT_ID NUMBER (15) Yes
TIME_ID NUMBER (15) Yes
PERIOD_TYPE_ID NUMBER (15) Yes
CALENDAR_TYPE VARCHAR2 (1) Yes
RBS_AGGR_LEVEL VARCHAR2 (1) Yes
WBS_ROLLUP_FLAG VARCHAR2 (1) Yes
PRG_ROLLUP_FLAG VARCHAR2 (1) Yes
CURR_RECORD_TYPE_ID NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (30) Yes
RBS_ELEMENT_ID NUMBER (15)
RBS_VERSION_ID NUMBER (15)
PLAN_VERSION_ID NUMBER (15) Yes
PLAN_TYPE_ID NUMBER (15) Yes
RAW_COST NUMBER

BRDN_COST NUMBER

REVENUE NUMBER

BILL_RAW_COST NUMBER

BILL_BRDN_COST NUMBER

BILL_LABOR_RAW_COST NUMBER

BILL_LABOR_BRDN_COST NUMBER

BILL_LABOR_HRS NUMBER

EQUIPMENT_RAW_COST NUMBER

EQUIPMENT_BRDN_COST NUMBER

CAPITALIZABLE_RAW_COST NUMBER

CAPITALIZABLE_BRDN_COST NUMBER

LABOR_RAW_COST NUMBER

LABOR_BRDN_COST NUMBER

LABOR_HRS NUMBER

LABOR_REVENUE NUMBER

EQUIPMENT_HOURS NUMBER

BILLABLE_EQUIPMENT_HOURS NUMBER

SUP_INV_COMMITTED_COST NUMBER

PO_COMMITTED_COST NUMBER

PR_COMMITTED_COST NUMBER

OTH_COMMITTED_COST NUMBER

CUSTOM1 NUMBER

CUSTOM2 NUMBER

CUSTOM3 NUMBER

CUSTOM4 NUMBER

CUSTOM5 NUMBER

CUSTOM6 NUMBER

CUSTOM7 NUMBER

CUSTOM8 NUMBER

CUSTOM9 NUMBER

CUSTOM10 NUMBER

CUSTOM11 NUMBER

CUSTOM12 NUMBER

CUSTOM13 NUMBER

CUSTOM14 NUMBER

CUSTOM15 NUMBER

LINE_TYPE VARCHAR2 (15)
RATE_DANGLING_FLAG VARCHAR2 (15)
TIME_DANGLING_FLAG VARCHAR2 (15)
START_DATE DATE

END_DATE DATE

ACT_LABOR_HRS NUMBER

ACT_EQUIP_HRS NUMBER

ACT_LABOR_BRDN_COST NUMBER

ACT_EQUIP_BRDN_COST NUMBER

ACT_BRDN_COST NUMBER

ACT_RAW_COST NUMBER

ACT_REVENUE NUMBER

ETC_LABOR_HRS NUMBER

ETC_EQUIP_HRS NUMBER

ETC_LABOR_BRDN_COST NUMBER

ETC_EQUIP_BRDN_COST NUMBER

ETC_BRDN_COST NUMBER

ETC_RAW_COST NUMBER

ACT_LABOR_RAW_COST NUMBER

ACT_EQUIP_RAW_COST NUMBER

ETC_LABOR_RAW_COST NUMBER

ETC_EQUIP_RAW_COST NUMBER

PLAN_TYPE_CODE VARCHAR2 (1)
Query Text

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


SELECT WORKER_ID
,      RECORD_TYPE
,      PRG_LEVEL
,      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
,      RAW_COST
,      BRDN_COST
,      REVENUE
,      BILL_RAW_COST
,      BILL_BRDN_COST
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_BRDN_COST
,      BILL_LABOR_HRS
,      EQUIPMENT_RAW_COST
,      EQUIPMENT_BRDN_COST
,      CAPITALIZABLE_RAW_COST
,      CAPITALIZABLE_BRDN_COST
,      LABOR_RAW_COST
,      LABOR_BRDN_COST
,      LABOR_HRS
,      LABOR_REVENUE
,      EQUIPMENT_HOURS
,      BILLABLE_EQUIPMENT_HOURS
,      SUP_INV_COMMITTED_COST
,      PO_COMMITTED_COST
,      PR_COMMITTED_COST
,      OTH_COMMITTED_COST
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
,      CUSTOM4
,      CUSTOM5
,      CUSTOM6
,      CUSTOM7
,      CUSTOM8
,      CUSTOM9
,      CUSTOM10
,      CUSTOM11
,      CUSTOM12
,      CUSTOM13
,      CUSTOM14
,      CUSTOM15
,      LINE_TYPE
,      RATE_DANGLING_FLAG
,      TIME_DANGLING_FLAG
,      START_DATE
,      END_DATE
,      ACT_LABOR_HRS
,      ACT_EQUIP_HRS
,      ACT_LABOR_BRDN_COST
,      ACT_EQUIP_BRDN_COST
,      ACT_BRDN_COST
,      ACT_RAW_COST
,      ACT_REVENUE
,      ETC_LABOR_HRS
,      ETC_EQUIP_HRS
,      ETC_LABOR_BRDN_COST
,      ETC_EQUIP_BRDN_COST
,      ETC_BRDN_COST
,      ETC_RAW_COST
,      ACT_LABOR_RAW_COST
,      ACT_EQUIP_RAW_COST
,      ETC_LABOR_RAW_COST
,      ETC_EQUIP_RAW_COST
,      PLAN_TYPE_CODE
FROM PJI.PJI_FP_AGGR_PJP2#;

Dependencies

[top of page]

PJI.PJI_FP_AGGR_PJP2# references the following:

SchemaPJI
TablePJI_FP_AGGR_PJP2
PJI.PJI_FP_AGGR_PJP2# is referenced by following:

SchemaAPPS
SynonymPJI_FP_AGGR_PJP2