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


TABLE: APPS.PJI_AV_ORGO_F_MV

Object Details
Object Name: PJI_AV_ORGO_F_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TablePJI.PJI_AV_ORGO_F_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_PJI_AV_ORGO_F_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnSYS_OP_MAP_NONNULL("EXPENDITURE_ORGANIZATION_ID")
ColumnSYS_OP_MAP_NONNULL("EXPENDITURE_ORG_ID")
ColumnSYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("TIME_ID")
ColumnSYS_OP_MAP_NONNULL("CALENDAR_TYPE")
ColumnSYS_OP_MAP_NONNULL("THRESHOLD")
ColumnSYS_OP_MAP_NONNULL("AS_OF_DATE")
PJI_AV_ORGO_F_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnCALENDAR_TYPE
ColumnEXPENDITURE_ORGANIZATION_ID
ColumnTHRESHOLD
Columns
Name Datatype Length Mandatory Comments
CNT NUMBER

EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORG_ID NUMBER (15)
PERIOD_TYPE_ID NUMBER (15)
TIME_ID NUMBER (15)
CALENDAR_TYPE VARCHAR2 (1)
THRESHOLD NUMBER

AS_OF_DATE NUMBER

BCKT_1_CS NUMBER

BCKT_1_CS_CNT NUMBER

BCKT_2_CS NUMBER

BCKT_2_CS_CNT NUMBER

BCKT_3_CS NUMBER

BCKT_3_CS_CNT NUMBER

BCKT_4_CS NUMBER

BCKT_4_CS_CNT NUMBER

BCKT_5_CS NUMBER

BCKT_5_CS_CNT NUMBER

BCKT_1_CM NUMBER

BCKT_1_CM_CNT NUMBER

BCKT_2_CM NUMBER

BCKT_2_CM_CNT NUMBER

BCKT_3_CM NUMBER

BCKT_3_CM_CNT NUMBER

BCKT_4_CM NUMBER

BCKT_4_CM_CNT NUMBER

BCKT_5_CM NUMBER

BCKT_5_CM_CNT NUMBER

TOTAL_RES_COUNT NUMBER

TOTAL_RES_COUNT_CNT NUMBER

Query Text

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


SELECT CNT
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG_ID
,      PERIOD_TYPE_ID
,      TIME_ID
,      CALENDAR_TYPE
,      THRESHOLD
,      AS_OF_DATE
,      BCKT_1_CS
,      BCKT_1_CS_CNT
,      BCKT_2_CS
,      BCKT_2_CS_CNT
,      BCKT_3_CS
,      BCKT_3_CS_CNT
,      BCKT_4_CS
,      BCKT_4_CS_CNT
,      BCKT_5_CS
,      BCKT_5_CS_CNT
,      BCKT_1_CM
,      BCKT_1_CM_CNT
,      BCKT_2_CM
,      BCKT_2_CM_CNT
,      BCKT_3_CM
,      BCKT_3_CM_CNT
,      BCKT_4_CM
,      BCKT_4_CM_CNT
,      BCKT_5_CM
,      BCKT_5_CM_CNT
,      TOTAL_RES_COUNT
,      TOTAL_RES_COUNT_CNT
FROM APPS.PJI_AV_ORGO_F_MV;

Dependencies

[top of page]

APPS.PJI_AV_ORGO_F_MV does not reference any database object

APPS.PJI_AV_ORGO_F_MV is referenced by following:

SchemaAPPS
Materialized ViewPJI_AV_ORGO_F_MV
Package BodyPJI_PMV_AVL - show dependent code