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


TABLE: APPS.POA_MID_BS_MV

Object Details
Object Name: POA_MID_BS_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.POA_MID_BS_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_POA_MID_BS_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_ID")
ColumnSYS_OP_MAP_NONNULL("INV_D_CREATED_BY")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_SITE_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("DAY_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
ColumnSYS_OP_MAP_NONNULL("AGGREGATION_LEVEL")
POA_MID_BS_MV_N1 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnORG_ID
POA_MID_BS_MV_N2 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnSUPPLIER_ID
ColumnSUPPLIER_SITE_ID
ColumnINV_D_CREATED_BY
Columns
Name Datatype Length Mandatory Comments
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Period Type Identifier
AGGREGATION_LEVEL NUMBER

ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
INV_D_CREATED_BY NUMBER (15)
Invoice Distribution Creator Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII Week Identifier
DAY_ID NUMBER

FII Day Identifier
DIST_COUNT NUMBER

Count of Invoice Distributions
C_DIST_COUNT NUMBER

Count Columns
MANUAL_DIST_COUNT NUMBER

Count of manual Invoice Distributions
C_MANUAL_DIST_COUNT NUMBER

Count Columns
C_TOTAL NUMBER

Row Count
Query Text

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


SELECT GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      AGGREGATION_LEVEL
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      INV_D_CREATED_BY
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      DIST_COUNT
,      C_DIST_COUNT
,      MANUAL_DIST_COUNT
,      C_MANUAL_DIST_COUNT
,      C_TOTAL
FROM APPS.POA_MID_BS_MV;

Dependencies

[top of page]

APPS.POA_MID_BS_MV does not reference any database object

APPS.POA_MID_BS_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_MID_BS_MV