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

MATERIALIZED VIEW: APPS.POA_API_BS_MV

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

POA_API_BS_J_MV
     FII_AP_INV_B
     FII_AP_INV_DIST_F
     FII_COM_CC_DIM_MAPS
     FII_TIME_DAY
     POA_DBI_POD_F
     PO_COMMODITY_CATEGORIES

[View Source Query]

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

Period Type Identifier
AGGREGATION_LEVEL NUMBER

Grouping ID Column
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
COMMODITY_ID NUMBER

Commodity Identifier
CATEGORY_ID NUMBER

Category on the PO Line Identifier
PO_ITEM_ID NUMBER

Purchased Item Identifier
BUYER_ID NUMBER

Buyer Identifier
SHIP_TO_ORG_ID NUMBER

Ship to Organization Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
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
AMOUNT_B NUMBER

Invoice Amount in Functional Currency
AMOUNT_G NUMBER

Invoice Amount in Global Currency
AMOUNT_SG NUMBER

Invoice Amount in Global Currency
C_AMOUNT_B NUMBER

Count Columns
C_AMOUNT_G NUMBER

Count Columns
C_AMOUNT_SG NUMBER

Invoice Amount in secondary Global Currency
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
,      COMMODITY_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BUYER_ID
,      SHIP_TO_ORG_ID
,      BASE_UOM
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AMOUNT_B
,      AMOUNT_G
,      AMOUNT_SG
,      C_AMOUNT_B
,      C_AMOUNT_G
,      C_AMOUNT_SG
,      C_TOTAL
FROM APPS.POA_API_BS_MV;

Dependencies

[top of page]

APPS.POA_API_BS_MV references the following:

SchemaAPPS
TablePOA_API_BS_J_MV
Materialized ViewPOA_API_BS_J_MV
TablePOA_API_BS_MV

APPS.POA_API_BS_MV is not referenced by any database object