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

TABLE: APPS.POA_BM_ITEM_O_MV

Object Details
Object Name: POA_BM_ITEM_O_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.POA_BM_ITEM_O_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_POA_BM_ITEM_O_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("PO_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("BASE_UOM")
POA_BM_ITEM_O_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnENT_YEAR_ID
ColumnPO_ITEM_ID
ColumnBASE_UOM
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
ORG_ID NUMBER

Operating Unit 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
PURCHASE_AMT_B NUMBER

Purchased Amount in functional currency
C_PURCHASE_AMT_B NUMBER

Count Columns
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
,      ORG_ID
,      PO_ITEM_ID
,      BASE_UOM
,      PURCHASE_AMT_G
,      C_PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      C_PURCHASE_AMT_SG
,      PURCHASE_AMT_B
,      C_PURCHASE_AMT_B
,      QUANTITY
,      C_QUANTITY
,      C_TOTAL
FROM APPS.POA_BM_ITEM_O_MV;

Dependencies

[top of page]

APPS.POA_BM_ITEM_O_MV does not reference any database object

APPS.POA_BM_ITEM_O_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_BM_ITEM_O_MV
Materialized ViewPOA_PQC_001_MV
Materialized ViewPOA_PQC_BS_J2_MV
Materialized ViewPOA_PQC_BS_MV
ViewPOA_PQC_BS_V