[Home] [Help] [Dependency Information]
Object Name: | PJI_FP_CLSO_F_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | PJI_FP_CLSO_F_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
PJI_FP_CLS_F_MV
PJI_FP_PROJ_F
PJI_PROJECT_CLASSES
PJI_ORG_DENORM
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | (15) | Yes | |
PROJECT_ORGANIZATION_ID | NUMBER | |||
CALENDAR_TYPE | VARCHAR2 | (30) | Yes | |
PERIOD_TYPE_ID | NUMBER | (15) | Yes | |
PROJECT_CLASS_ID | NUMBER | (15) | Yes | |
CURR_RECORD_TYPE_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (30) | ||
PROJECT_ORG_ID | NUMBER | (15) | Yes | |
CNT | NUMBER | |||
REVENUE | NUMBER | |||
REVENUE_CNT | NUMBER | |||
LABOR_REVENUE | NUMBER | |||
LABOR_REVENUE_CNT | NUMBER | |||
RAW_COST | NUMBER | |||
RAW_COST_CNT | NUMBER | |||
BURDENED_COST | NUMBER | |||
BURDENED_COST_CNT | NUMBER | |||
BILL_RAW_COST | NUMBER | |||
BILL_RAW_COST_CNT | NUMBER | |||
BILL_BURDENED_COST | NUMBER | |||
BILL_BURDENED_COST_CNT | NUMBER | |||
LABOR_RAW_COST | NUMBER | |||
LABOR_RAW_COST_CNT | NUMBER | |||
LABOR_BURDENED_COST | NUMBER | |||
LABOR_BURDENED_COST_CNT | NUMBER | |||
BILL_LABOR_RAW_COST | NUMBER | |||
BILL_LABOR_RAW_COST_CNT | NUMBER | |||
BILL_LABOR_BURDENED_COST | NUMBER | |||
BILL_LABOR_BURDENED_COST_CNT | NUMBER | |||
CAPITAL_RAW_COST | NUMBER | |||
CAPITAL_RAW_COST_CNT | NUMBER | |||
CAPITAL_BRDN_COST | NUMBER | |||
CAPITAL_BRDN_COST_CNT | NUMBER | |||
CONTRACT_RAW_COST | NUMBER | |||
CONTRACT_RAW_COST_CNT | NUMBER | |||
CONTRACT_BRDN_COST | NUMBER | |||
CONTRACT_BRDN_COST_CNT | NUMBER | |||
CAPITALIZABLE_RAW_COST | NUMBER | |||
CAPITALIZABLE_RAW_COST_CNT | NUMBER | |||
CAPITALIZABLE_BRDN_COST | NUMBER | |||
CAPITALIZABLE_BRDN_COST_CNT | NUMBER | |||
PROJECT_COUNT | NUMBER | |||
PROJECT_COUNT_CNT | NUMBER | |||
REVENUE_WRITEOFF | NUMBER | |||
REVENUE_WRITEOFF_CNT | NUMBER | |||
CURR_BGT_REVENUE | NUMBER | |||
CURR_BGT_REVENUE_CNT | NUMBER | |||
CURR_BGT_RAW_COST | NUMBER | |||
CURR_BGT_RAW_COST_CNT | NUMBER | |||
CURR_BGT_BURDENED_COST | NUMBER | |||
CURR_BGT_BURDENED_COST_CNT | NUMBER | |||
CURR_BGT_LABOR_HRS | NUMBER | |||
CURR_BGT_LABOR_HRS_CNT | NUMBER | |||
ORIG_BGT_REVENUE | NUMBER | |||
ORIG_BGT_REVENUE_CNT | NUMBER | |||
ORIG_BGT_RAW_COST | NUMBER | |||
ORIG_BGT_RAW_COST_CNT | NUMBER | |||
ORIG_BGT_BURDENED_COST | NUMBER | |||
ORIG_BGT_BURDENED_COST_CNT | NUMBER | |||
ORIG_BGT_LABOR_HRS | NUMBER | |||
ORIG_BGT_LABOR_HRS_CNT | NUMBER | |||
FORECAST_REVENUE | NUMBER | |||
FORECAST_REVENUE_CNT | NUMBER | |||
FORECAST_RAW_COST | NUMBER | |||
FORECAST_RAW_COST_CNT | NUMBER | |||
FORECAST_BURDENED_COST | NUMBER | |||
FORECAST_BURDENED_COST_CNT | NUMBER | |||
FORECAST_LABOR_HRS | NUMBER | |||
FORECAST_LABOR_HRS_CNT | NUMBER | |||
CAP_CURR_BGT_RAW_COST | NUMBER | |||
CAP_CURR_BGT_RAW_COST_CNT | NUMBER | |||
CAP_CURR_BGT_BRDN_COST | NUMBER | |||
CAP_CURR_BGT_BRDN_COST_CNT | NUMBER | |||
CAP_ORIG_BGT_RAW_COST | NUMBER | |||
CAP_ORIG_BGT_RAW_COST_CNT | NUMBER | |||
CAP_ORIG_BGT_BRDN_COST | NUMBER | |||
CAP_ORIG_BGT_BRDN_COST_CNT | NUMBER | |||
CAP_FORECAST_RAW_COST | NUMBER | |||
CAP_FORECAST_RAW_COST_CNT | NUMBER | |||
CAP_FORECAST_BRDN_COST | NUMBER | |||
CAP_FORECAST_BRDN_COST_CNT | NUMBER | |||
CON_CURR_BGT_RAW_COST | NUMBER | |||
CON_CURR_BGT_RAW_COST_CNT | NUMBER | |||
CON_CURR_BGT_BRDN_COST | NUMBER | |||
CON_CURR_BGT_BRDN_COST_CNT | NUMBER | |||
CON_ORIG_BGT_RAW_COST | NUMBER | |||
CON_ORIG_BGT_RAW_COST_CNT | NUMBER | |||
CON_ORIG_BGT_BRDN_COST | NUMBER | |||
CON_ORIG_BGT_BRDN_COST_CNT | NUMBER | |||
CON_FORECAST_RAW_COST | NUMBER | |||
CON_FORECAST_RAW_COST_CNT | NUMBER | |||
CON_FORECAST_BRDN_COST | NUMBER | |||
CON_FORECAST_BRDN_COST_CNT | NUMBER | |||
LABOR_HRS | NUMBER | |||
LABOR_HRS_CNT | NUMBER | |||
BILL_LABOR_HRS | NUMBER | |||
BILL_LABOR_HRS_CNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PROJECT_ORGANIZATION_ID
, CALENDAR_TYPE
, PERIOD_TYPE_ID
, PROJECT_CLASS_ID
, CURR_RECORD_TYPE_ID
, CURRENCY_CODE
, PROJECT_ORG_ID
, CNT
, REVENUE
, REVENUE_CNT
, LABOR_REVENUE
, LABOR_REVENUE_CNT
, RAW_COST
, RAW_COST_CNT
, BURDENED_COST
, BURDENED_COST_CNT
, BILL_RAW_COST
, BILL_RAW_COST_CNT
, BILL_BURDENED_COST
, BILL_BURDENED_COST_CNT
, LABOR_RAW_COST
, LABOR_RAW_COST_CNT
, LABOR_BURDENED_COST
, LABOR_BURDENED_COST_CNT
, BILL_LABOR_RAW_COST
, BILL_LABOR_RAW_COST_CNT
, BILL_LABOR_BURDENED_COST
, BILL_LABOR_BURDENED_COST_CNT
, CAPITAL_RAW_COST
, CAPITAL_RAW_COST_CNT
, CAPITAL_BRDN_COST
, CAPITAL_BRDN_COST_CNT
, CONTRACT_RAW_COST
, CONTRACT_RAW_COST_CNT
, CONTRACT_BRDN_COST
, CONTRACT_BRDN_COST_CNT
, CAPITALIZABLE_RAW_COST
, CAPITALIZABLE_RAW_COST_CNT
, CAPITALIZABLE_BRDN_COST
, CAPITALIZABLE_BRDN_COST_CNT
, PROJECT_COUNT
, PROJECT_COUNT_CNT
, REVENUE_WRITEOFF
, REVENUE_WRITEOFF_CNT
, CURR_BGT_REVENUE
, CURR_BGT_REVENUE_CNT
, CURR_BGT_RAW_COST
, CURR_BGT_RAW_COST_CNT
, CURR_BGT_BURDENED_COST
, CURR_BGT_BURDENED_COST_CNT
, CURR_BGT_LABOR_HRS
, CURR_BGT_LABOR_HRS_CNT
, ORIG_BGT_REVENUE
, ORIG_BGT_REVENUE_CNT
, ORIG_BGT_RAW_COST
, ORIG_BGT_RAW_COST_CNT
, ORIG_BGT_BURDENED_COST
, ORIG_BGT_BURDENED_COST_CNT
, ORIG_BGT_LABOR_HRS
, ORIG_BGT_LABOR_HRS_CNT
, FORECAST_REVENUE
, FORECAST_REVENUE_CNT
, FORECAST_RAW_COST
, FORECAST_RAW_COST_CNT
, FORECAST_BURDENED_COST
, FORECAST_BURDENED_COST_CNT
, FORECAST_LABOR_HRS
, FORECAST_LABOR_HRS_CNT
, CAP_CURR_BGT_RAW_COST
, CAP_CURR_BGT_RAW_COST_CNT
, CAP_CURR_BGT_BRDN_COST
, CAP_CURR_BGT_BRDN_COST_CNT
, CAP_ORIG_BGT_RAW_COST
, CAP_ORIG_BGT_RAW_COST_CNT
, CAP_ORIG_BGT_BRDN_COST
, CAP_ORIG_BGT_BRDN_COST_CNT
, CAP_FORECAST_RAW_COST
, CAP_FORECAST_RAW_COST_CNT
, CAP_FORECAST_BRDN_COST
, CAP_FORECAST_BRDN_COST_CNT
, CON_CURR_BGT_RAW_COST
, CON_CURR_BGT_RAW_COST_CNT
, CON_CURR_BGT_BRDN_COST
, CON_CURR_BGT_BRDN_COST_CNT
, CON_ORIG_BGT_RAW_COST
, CON_ORIG_BGT_RAW_COST_CNT
, CON_ORIG_BGT_BRDN_COST
, CON_ORIG_BGT_BRDN_COST_CNT
, CON_FORECAST_RAW_COST
, CON_FORECAST_RAW_COST_CNT
, CON_FORECAST_BRDN_COST
, CON_FORECAST_BRDN_COST_CNT
, LABOR_HRS
, LABOR_HRS_CNT
, BILL_LABOR_HRS
, BILL_LABOR_HRS_CNT
FROM APPS.PJI_FP_CLSO_F_MV;
APPS.PJI_FP_CLSO_F_MV is not referenced by any database object
|
|
|