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


TABLE: APPS.MLOG$_PJI_FP_CLS_F_MV

Object Details
Object Name: MLOG$_PJI_FP_CLS_F_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.PJI_FP_CLS_F_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BILL_BURDENED_COST NUMBER

BILL_BURDENED_COST_CNT NUMBER

BILL_LABOR_BURDENED_COST NUMBER

BILL_LABOR_BURDENED_COST_CNT NUMBER

BILL_LABOR_HRS NUMBER

BILL_LABOR_HRS_CNT NUMBER

BILL_LABOR_RAW_COST NUMBER

BILL_LABOR_RAW_COST_CNT NUMBER

BILL_RAW_COST NUMBER

BILL_RAW_COST_CNT NUMBER

BURDENED_COST NUMBER

BURDENED_COST_CNT NUMBER

CALENDAR_TYPE VARCHAR2 (30)
CAPITALIZABLE_BRDN_COST NUMBER

CAPITALIZABLE_BRDN_COST_CNT NUMBER

CAPITALIZABLE_RAW_COST NUMBER

CAPITALIZABLE_RAW_COST_CNT NUMBER

CAPITAL_BRDN_COST NUMBER

CAPITAL_BRDN_COST_CNT NUMBER

CAPITAL_RAW_COST NUMBER

CAPITAL_RAW_COST_CNT NUMBER

CAP_CURR_BGT_BRDN_COST NUMBER

CAP_CURR_BGT_BRDN_COST_CNT NUMBER

CAP_CURR_BGT_RAW_COST NUMBER

CAP_CURR_BGT_RAW_COST_CNT NUMBER

CAP_FORECAST_BRDN_COST NUMBER

CAP_FORECAST_BRDN_COST_CNT NUMBER

CAP_FORECAST_RAW_COST NUMBER

CAP_FORECAST_RAW_COST_CNT NUMBER

CAP_ORIG_BGT_BRDN_COST NUMBER

CAP_ORIG_BGT_BRDN_COST_CNT NUMBER

CAP_ORIG_BGT_RAW_COST NUMBER

CAP_ORIG_BGT_RAW_COST_CNT NUMBER

CNT NUMBER

CONTRACT_BRDN_COST NUMBER

CONTRACT_BRDN_COST_CNT NUMBER

CONTRACT_RAW_COST NUMBER

CONTRACT_RAW_COST_CNT NUMBER

CON_CURR_BGT_BRDN_COST NUMBER

CON_CURR_BGT_BRDN_COST_CNT NUMBER

CON_CURR_BGT_RAW_COST NUMBER

CON_CURR_BGT_RAW_COST_CNT NUMBER

CON_FORECAST_BRDN_COST NUMBER

CON_FORECAST_BRDN_COST_CNT NUMBER

CON_FORECAST_RAW_COST NUMBER

CON_FORECAST_RAW_COST_CNT NUMBER

CON_ORIG_BGT_BRDN_COST NUMBER

CON_ORIG_BGT_BRDN_COST_CNT NUMBER

CON_ORIG_BGT_RAW_COST NUMBER

CON_ORIG_BGT_RAW_COST_CNT NUMBER

CURRENCY_CODE VARCHAR2 (30)
CURR_BGT_BURDENED_COST NUMBER

CURR_BGT_BURDENED_COST_CNT NUMBER

CURR_BGT_LABOR_HRS NUMBER

CURR_BGT_LABOR_HRS_CNT NUMBER

CURR_BGT_RAW_COST NUMBER

CURR_BGT_RAW_COST_CNT NUMBER

CURR_BGT_REVENUE NUMBER

CURR_BGT_REVENUE_CNT NUMBER

CURR_RECORD_TYPE_ID NUMBER (15)
FORECAST_BURDENED_COST NUMBER

FORECAST_BURDENED_COST_CNT NUMBER

FORECAST_LABOR_HRS NUMBER

FORECAST_LABOR_HRS_CNT NUMBER

FORECAST_RAW_COST NUMBER

FORECAST_RAW_COST_CNT NUMBER

FORECAST_REVENUE NUMBER

FORECAST_REVENUE_CNT NUMBER

LABOR_BURDENED_COST NUMBER

LABOR_BURDENED_COST_CNT NUMBER

LABOR_HRS NUMBER

LABOR_HRS_CNT NUMBER

LABOR_RAW_COST NUMBER

LABOR_RAW_COST_CNT NUMBER

LABOR_REVENUE NUMBER

LABOR_REVENUE_CNT NUMBER

ORIG_BGT_BURDENED_COST NUMBER

ORIG_BGT_BURDENED_COST_CNT NUMBER

ORIG_BGT_LABOR_HRS NUMBER

ORIG_BGT_LABOR_HRS_CNT NUMBER

ORIG_BGT_RAW_COST NUMBER

ORIG_BGT_RAW_COST_CNT NUMBER

ORIG_BGT_REVENUE NUMBER

ORIG_BGT_REVENUE_CNT NUMBER

PERIOD_TYPE_ID NUMBER (15)
PROJECT_CLASS_ID NUMBER (15)
PROJECT_COUNT NUMBER

PROJECT_COUNT_CNT NUMBER

PROJECT_ORGANIZATION_ID NUMBER (15)
PROJECT_ORG_ID NUMBER (15)
RAW_COST NUMBER

RAW_COST_CNT NUMBER

REVENUE NUMBER

REVENUE_CNT NUMBER

REVENUE_WRITEOFF NUMBER

REVENUE_WRITEOFF_CNT NUMBER

TIME_ID NUMBER (15)
M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT BILL_BURDENED_COST
,      BILL_BURDENED_COST_CNT
,      BILL_LABOR_BURDENED_COST
,      BILL_LABOR_BURDENED_COST_CNT
,      BILL_LABOR_HRS
,      BILL_LABOR_HRS_CNT
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_RAW_COST_CNT
,      BILL_RAW_COST
,      BILL_RAW_COST_CNT
,      BURDENED_COST
,      BURDENED_COST_CNT
,      CALENDAR_TYPE
,      CAPITALIZABLE_BRDN_COST
,      CAPITALIZABLE_BRDN_COST_CNT
,      CAPITALIZABLE_RAW_COST
,      CAPITALIZABLE_RAW_COST_CNT
,      CAPITAL_BRDN_COST
,      CAPITAL_BRDN_COST_CNT
,      CAPITAL_RAW_COST
,      CAPITAL_RAW_COST_CNT
,      CAP_CURR_BGT_BRDN_COST
,      CAP_CURR_BGT_BRDN_COST_CNT
,      CAP_CURR_BGT_RAW_COST
,      CAP_CURR_BGT_RAW_COST_CNT
,      CAP_FORECAST_BRDN_COST
,      CAP_FORECAST_BRDN_COST_CNT
,      CAP_FORECAST_RAW_COST
,      CAP_FORECAST_RAW_COST_CNT
,      CAP_ORIG_BGT_BRDN_COST
,      CAP_ORIG_BGT_BRDN_COST_CNT
,      CAP_ORIG_BGT_RAW_COST
,      CAP_ORIG_BGT_RAW_COST_CNT
,      CNT
,      CONTRACT_BRDN_COST
,      CONTRACT_BRDN_COST_CNT
,      CONTRACT_RAW_COST
,      CONTRACT_RAW_COST_CNT
,      CON_CURR_BGT_BRDN_COST
,      CON_CURR_BGT_BRDN_COST_CNT
,      CON_CURR_BGT_RAW_COST
,      CON_CURR_BGT_RAW_COST_CNT
,      CON_FORECAST_BRDN_COST
,      CON_FORECAST_BRDN_COST_CNT
,      CON_FORECAST_RAW_COST
,      CON_FORECAST_RAW_COST_CNT
,      CON_ORIG_BGT_BRDN_COST
,      CON_ORIG_BGT_BRDN_COST_CNT
,      CON_ORIG_BGT_RAW_COST
,      CON_ORIG_BGT_RAW_COST_CNT
,      CURRENCY_CODE
,      CURR_BGT_BURDENED_COST
,      CURR_BGT_BURDENED_COST_CNT
,      CURR_BGT_LABOR_HRS
,      CURR_BGT_LABOR_HRS_CNT
,      CURR_BGT_RAW_COST
,      CURR_BGT_RAW_COST_CNT
,      CURR_BGT_REVENUE
,      CURR_BGT_REVENUE_CNT
,      CURR_RECORD_TYPE_ID
,      FORECAST_BURDENED_COST
,      FORECAST_BURDENED_COST_CNT
,      FORECAST_LABOR_HRS
,      FORECAST_LABOR_HRS_CNT
,      FORECAST_RAW_COST
,      FORECAST_RAW_COST_CNT
,      FORECAST_REVENUE
,      FORECAST_REVENUE_CNT
,      LABOR_BURDENED_COST
,      LABOR_BURDENED_COST_CNT
,      LABOR_HRS
,      LABOR_HRS_CNT
,      LABOR_RAW_COST
,      LABOR_RAW_COST_CNT
,      LABOR_REVENUE
,      LABOR_REVENUE_CNT
,      ORIG_BGT_BURDENED_COST
,      ORIG_BGT_BURDENED_COST_CNT
,      ORIG_BGT_LABOR_HRS
,      ORIG_BGT_LABOR_HRS_CNT
,      ORIG_BGT_RAW_COST
,      ORIG_BGT_RAW_COST_CNT
,      ORIG_BGT_REVENUE
,      ORIG_BGT_REVENUE_CNT
,      PERIOD_TYPE_ID
,      PROJECT_CLASS_ID
,      PROJECT_COUNT
,      PROJECT_COUNT_CNT
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ORG_ID
,      RAW_COST
,      RAW_COST_CNT
,      REVENUE
,      REVENUE_CNT
,      REVENUE_WRITEOFF
,      REVENUE_WRITEOFF_CNT
,      TIME_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_PJI_FP_CLS_F_MV;

Dependencies

[top of page]

APPS.MLOG$_PJI_FP_CLS_F_MV does not reference any database object

APPS.MLOG$_PJI_FP_CLS_F_MV is not referenced by any database object