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

TABLE: PJI.PJI_ORG_DENORM

Object Details
Object Name: PJI_ORG_DENORM
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_ORG_DENORM
Subobject Name:
Status: VALID


This table stores deflated structure of organization hierarchy.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_ORG_DENORM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSUB_ORGANIZATION_ID
PJI_ORG_DENORM_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUB_ORGANIZATION_ID
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Identifier for organization.
SUB_ORGANIZATION_ID NUMBER

Identifier for subordinate organization.
ORGANIZATION_LEVEL NUMBER

Organization level
SUB_ORGANIZATION_LEVEL NUMBER

Subordinate organization level
Query Text

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


SELECT ORGANIZATION_ID
,      SUB_ORGANIZATION_ID
,      ORGANIZATION_LEVEL
,      SUB_ORGANIZATION_LEVEL
FROM PJI.PJI_ORG_DENORM;

Dependencies

[top of page]

PJI.PJI_ORG_DENORM does not reference any database object

PJI.PJI_ORG_DENORM is referenced by following:

SchemaAPPS
Materialized ViewPJI_AC_CLSO_F_MV
Materialized ViewPJI_AC_ORGO_F_MV
Materialized ViewPJI_AV_ORGO_F_MV
Materialized ViewPJI_CA_ORGO_F_MV
Materialized ViewPJI_FP_CLSO_ET_F_MV
Materialized ViewPJI_FP_CLSO_ET_WT_F_MV
Materialized ViewPJI_FP_CLSO_F_MV
Materialized ViewPJI_FP_ORGO_ET_F_MV
Materialized ViewPJI_FP_ORGO_ET_WT_F_MV
Materialized ViewPJI_FP_ORGO_F_MV
SynonymPJI_ORG_DENORM
Materialized ViewPJI_RM_JOBO_F_MV
Materialized ViewPJI_RM_ORGO_F_MV
Materialized ViewPJI_RM_WTO_F_MV