[Home] [Help] [Dependency Information]
Object Name: | PJI_FP_ORG_ET_WT_F_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | PJI_FP_ORG_ET_WT_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_PROJ_ET_WT_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | Yes | |
CALENDAR_TYPE | VARCHAR2 | (30) | Yes | |
PERIOD_TYPE_ID | NUMBER | (15) | Yes | |
CURR_RECORD_TYPE_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | (15) | Yes | |
EXP_EVT_TYPE_ID | NUMBER | (15) | Yes | |
WORK_TYPE_ID | NUMBER | (15) | Yes | |
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 | |||
LABOR_HRS | NUMBER | |||
LABOR_HRS_CNT | NUMBER | |||
BILL_LABOR_HRS | NUMBER | |||
BILL_LABOR_HRS_CNT | NUMBER | |||
QUANTITY | NUMBER | |||
QUANTITY_CNT | NUMBER | |||
BILL_QUANTITY | NUMBER | |||
BILL_QUANTITY_CNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, ORGANIZATION_ID
, CALENDAR_TYPE
, PERIOD_TYPE_ID
, CURR_RECORD_TYPE_ID
, CURRENCY_CODE
, ORG_ID
, EXP_EVT_TYPE_ID
, WORK_TYPE_ID
, 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
, LABOR_HRS
, LABOR_HRS_CNT
, BILL_LABOR_HRS
, BILL_LABOR_HRS_CNT
, QUANTITY
, QUANTITY_CNT
, BILL_QUANTITY
, BILL_QUANTITY_CNT
FROM APPS.PJI_FP_ORG_ET_WT_F_MV;
|
|
|