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

MATERIALIZED VIEW: APPS.POA_MID_BS_J_MV

Object Details
Object Name: POA_MID_BS_J_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: POA_MID_BS_J_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: TEXTMATCH
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

AP_SUPPLIERS
FII_AP_INV_B
FII_AP_INV_DIST_F
FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARKER NUMBER

Union Operator Marker
FRID ROWID (10)
FRID
CRID ROWID (10)
CRID
VRID ROWID (10)
VRID
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
SOURCE VARCHAR2 (25)
Source of Invoice
ENT_YEAR_ID NUMBER

Enterprise Year 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
Query Text

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


SELECT UMARKER
,      FRID
,      CRID
,      VRID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      INV_D_CREATED_BY
,      SOURCE
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      DIST_COUNT
FROM APPS.POA_MID_BS_J_MV;

Dependencies

[top of page]

APPS.POA_MID_BS_J_MV references the following:

SchemaAP
TableAP_SUPPLIERS
SchemaAPPS
TablePOA_MID_BS_J_MV
SchemaFII
TableFII_AP_INV_B
TableFII_AP_INV_DIST_F
TableFII_TIME_DAY
APPS.POA_MID_BS_J_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_MID_BS_MV