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

TABLE: PJI.MLOG$_PJI_AV_ORG_F

Object Details
Object Name: MLOG$_PJI_AV_ORG_F
Object Type: TABLE
Owner: PJI
Subobject Name:
Status: VALID

snapshot log for master table PJI.PJI_AV_ORG_F

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

BCKT_1_CM NUMBER

BCKT_1_CS NUMBER

BCKT_2_CM NUMBER

BCKT_2_CS NUMBER

BCKT_3_CM NUMBER

BCKT_3_CS NUMBER

BCKT_4_CM NUMBER

BCKT_4_CS NUMBER

BCKT_5_CM NUMBER

BCKT_5_CS NUMBER

CALENDAR_TYPE VARCHAR2 (1)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

EXPENDITURE_ORGANIZATION_ID NUMBER (15)
EXPENDITURE_ORG_ID NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
PERIOD_TYPE_ID NUMBER (15)
THRESHOLD NUMBER

TIME_ID NUMBER (15)
TOTAL_RES_COUNT NUMBER

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 AS_OF_DATE
,      BCKT_1_CM
,      BCKT_1_CS
,      BCKT_2_CM
,      BCKT_2_CS
,      BCKT_3_CM
,      BCKT_3_CS
,      BCKT_4_CM
,      BCKT_4_CS
,      BCKT_5_CM
,      BCKT_5_CS
,      CALENDAR_TYPE
,      CREATED_BY
,      CREATION_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERIOD_TYPE_ID
,      THRESHOLD
,      TIME_ID
,      TOTAL_RES_COUNT
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM PJI.MLOG$_PJI_AV_ORG_F;

Dependencies

[top of page]

PJI.MLOG$_PJI_AV_ORG_F does not reference any database object

PJI.MLOG$_PJI_AV_ORG_F is referenced by following:

SchemaAPPS
SynonymMLOG$_PJI_AV_ORG_F