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

MATERIALIZED VIEW: APPS.POA_BM_ITEM_S_MV

Object Details
Object Name: POA_BM_ITEM_S_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: POA_BM_ITEM_S_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_PQC_BS_J_MV
     FII_COM_CC_DIM_MAPS
     FII_TIME_DAY
     POA_DBI_POD_F
     PO_COMMODITY_CATEGORIES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
PO_ITEM_ID NUMBER
Yes Purchased Item Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
PURCHASE_AMT_G NUMBER

Purchased Amount in global currency
C_PURCHASE_AMT_G NUMBER

Count
PURCHASE_AMT_SG NUMBER

Purchased Amount in secondary global currency
C_PURCHASE_AMT_SG NUMBER

Count
QUANTITY NUMBER

Quantity in Base UOM
C_QUANTITY NUMBER

Count Columns
C_TOTAL NUMBER

Row Count
Query Text

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


SELECT ENT_YEAR_ID
,      SUPPLIER_ID
,      PO_ITEM_ID
,      BASE_UOM
,      PURCHASE_AMT_G
,      C_PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      C_PURCHASE_AMT_SG
,      QUANTITY
,      C_QUANTITY
,      C_TOTAL
FROM APPS.POA_BM_ITEM_S_MV;

Dependencies

[top of page]

APPS.POA_BM_ITEM_S_MV references the following:

SchemaAPPS
TablePOA_BM_ITEM_S_MV
TablePOA_PQC_BS_J_MV
Materialized ViewPOA_PQC_BS_J_MV
APPS.POA_BM_ITEM_S_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_PQC_001_MV
Materialized ViewPOA_PQC_BS_J2_MV
Materialized ViewPOA_PQC_BS_MV