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

TABLE: APPS.POA_PQC_002_MV

Object Details
Object Name: POA_PQC_002_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.POA_PQC_002_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_POA_PQC_002_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("PARENT_COMPANY_ID")
ColumnSYS_OP_MAP_NONNULL("PARENT_CC_ID")
ColumnSYS_OP_MAP_NONNULL("COMPANY_ID")
ColumnSYS_OP_MAP_NONNULL("COST_CENTER_ID")
ColumnSYS_OP_MAP_NONNULL("TIME_ID")
ColumnSYS_OP_MAP_NONNULL("COMMODITY_ID")
ColumnSYS_OP_MAP_NONNULL("CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_ID")
ColumnSYS_OP_MAP_NONNULL("PO_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("BASE_UOM")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
ColumnSYS_OP_MAP_NONNULL("AGGREGATION_LEVEL")
POA_PQC_002_MV_N1 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMPANY_ID
ColumnCOST_CENTER_ID
Columns
Name Datatype Length Mandatory Comments
GRP_ID NUMBER

Grouping ID Column
ORG_ID NUMBER

Operating Unit Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
COMMODITY_ID NUMBER

Commodity Identifier
CATEGORY_ID NUMBER

Category on the PO Line Identifier
PO_ITEM_ID NUMBER

Purchased Item Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
PARENT_COMPANY_ID NUMBER (15)
Parent Company Identifier
PARENT_CC_ID NUMBER (15)
Parent Cost-center Identifier
COMPANY_ID NUMBER (15)
Company Identifier
COST_CENTER_ID NUMBER (15)
Cost-center Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
PBCQCO_AMT_G NUMBER

Benchmark fallback amount per OU in global currency, ie, Current quantity * Current enterprise year benchmark price
PBCQCO_AMT_SG NUMBER

Benchmark fallback amount per OU in secondary global currency, ie, Current quantity * Current enterprise year benchmark price
C_PBCQCO_AMT_G NUMBER

Count Columns
C_PBCQCO_AMT_SG NUMBER

Count Columns
PBCQCO_AMT_B NUMBER

Benchmark fallback amount per OU in functional currency, ie, Current quantity * Current enterprise year benchmark price
C_PBCQCO_AMT_B NUMBER

Count Columns
PBPCQCO_AMT_G NUMBER

Benchmark amount per OU in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist)
PBPCQCO_AMT_SG NUMBER

Benchmark amount per OU in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist)
C_PBPCQCO_AMT_G NUMBER

Count Columns
C_PBPCQCO_AMT_SG NUMBER

Count Columns
PBPCQCO_AMT_B NUMBER

Benchmark amount per OU in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist)
C_PBPCQCO_AMT_B NUMBER

Count Columns
PBPCQCS_AMT_G NUMBER

Benchmark amount per supplier in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist)
PBPCQCS_AMT_SG NUMBER

Benchmark amount per supplier in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist)
C_PBPCQCS_AMT_G NUMBER

Count Columns
C_PBPCQCS_AMT_SG NUMBER

Count Columns
PBPCQCS_AMT_B NUMBER

Benchmark amount per supplier in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist)
C_PBPCQCS_AMT_B NUMBER

Count Columns
PURCHASE_AMT_B NUMBER

Purchased Amount in functional currency
C_PURCHASE_AMT_B NUMBER

Count Columns
PURCHASE_AMT_G NUMBER

Purchased Amount in global currency
PURCHASE_AMT_SG NUMBER

Purchased Amount in secondary global currency
C_PURCHASE_AMT_G NUMBER

Count
C_PURCHASE_AMT_SG NUMBER

Count
QUANTITY NUMBER

Quantity in Base UOM
C_QUANTITY NUMBER

Count Columns
C_TOTAL NUMBER

Row Count
AGGREGATION_LEVEL NUMBER

Grouping ID Column
Query Text

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


SELECT GRP_ID
,      ORG_ID
,      SUPPLIER_ID
,      COMMODITY_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BASE_UOM
,      PARENT_COMPANY_ID
,      PARENT_CC_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      TIME_ID
,      PBCQCO_AMT_G
,      PBCQCO_AMT_SG
,      C_PBCQCO_AMT_G
,      C_PBCQCO_AMT_SG
,      PBCQCO_AMT_B
,      C_PBCQCO_AMT_B
,      PBPCQCO_AMT_G
,      PBPCQCO_AMT_SG
,      C_PBPCQCO_AMT_G
,      C_PBPCQCO_AMT_SG
,      PBPCQCO_AMT_B
,      C_PBPCQCO_AMT_B
,      PBPCQCS_AMT_G
,      PBPCQCS_AMT_SG
,      C_PBPCQCS_AMT_G
,      C_PBPCQCS_AMT_SG
,      PBPCQCS_AMT_B
,      C_PBPCQCS_AMT_B
,      PURCHASE_AMT_B
,      C_PURCHASE_AMT_B
,      PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      C_PURCHASE_AMT_G
,      C_PURCHASE_AMT_SG
,      QUANTITY
,      C_QUANTITY
,      C_TOTAL
,      AGGREGATION_LEVEL
FROM APPS.POA_PQC_002_MV;

Dependencies

[top of page]

APPS.POA_PQC_002_MV does not reference any database object

APPS.POA_PQC_002_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_PQC_002_MV