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

TABLE: APPS.MLOG$_PJI_RM_WT_F_MV

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

snapshot log for master table APPS.PJI_RM_WT_F_MV

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

BILL_HRS_A_CNT NUMBER

CALENDAR_TYPE VARCHAR2 (1)
CAPACITY_HRS NUMBER

CAPACITY_HRS_CNT NUMBER

CNT NUMBER

CONF_HRS_S NUMBER

CONF_HRS_S_CNT NUMBER

CONF_OVERCOM_HRS_S NUMBER

CONF_OVERCOM_HRS_S_CNT NUMBER

EXPENDITURE_ORGANIZATION_ID NUMBER (15)
EXPENDITURE_ORG_ID NUMBER (15)
PERIOD_TYPE_ID NUMBER (15)
PROV_HRS_S NUMBER

PROV_HRS_S_CNT NUMBER

PROV_OVERCOM_HRS_S NUMBER

PROV_OVERCOM_HRS_S_CNT NUMBER

TIME_ID NUMBER (15)
TOTAL_HRS_A NUMBER

TOTAL_HRS_A_CNT NUMBER

UNASSIGNED_HRS_S NUMBER

UNASSIGNED_HRS_S_CNT NUMBER

WORK_TYPE_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_HRS_A
,      BILL_HRS_A_CNT
,      CALENDAR_TYPE
,      CAPACITY_HRS
,      CAPACITY_HRS_CNT
,      CNT
,      CONF_HRS_S
,      CONF_HRS_S_CNT
,      CONF_OVERCOM_HRS_S
,      CONF_OVERCOM_HRS_S_CNT
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG_ID
,      PERIOD_TYPE_ID
,      PROV_HRS_S
,      PROV_HRS_S_CNT
,      PROV_OVERCOM_HRS_S
,      PROV_OVERCOM_HRS_S_CNT
,      TIME_ID
,      TOTAL_HRS_A
,      TOTAL_HRS_A_CNT
,      UNASSIGNED_HRS_S
,      UNASSIGNED_HRS_S_CNT
,      WORK_TYPE_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_PJI_RM_WT_F_MV;

Dependencies

[top of page]

APPS.MLOG$_PJI_RM_WT_F_MV does not reference any database object

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