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

TABLE: APPS.POA_POD_BS_MV

Object Details
Object Name: POA_POD_BS_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.POA_POD_BS_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_POA_POD_BS_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("COMMODITY_ID")
ColumnSYS_OP_MAP_NONNULL("CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_SITE_ID")
ColumnSYS_OP_MAP_NONNULL("PO_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("BASE_UOM")
ColumnSYS_OP_MAP_NONNULL("BUYER_ID")
ColumnSYS_OP_MAP_NONNULL("CONTRACT_TYPE")
ColumnSYS_OP_MAP_NONNULL("NEGOTIATION_CREATOR_ID")
ColumnSYS_OP_MAP_NONNULL("DOCTYPE_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("DAY_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
ColumnSYS_OP_MAP_NONNULL("AGGREGATION_LEVEL")
POA_POD_BS_MV_N1 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnCATEGORY_ID
ColumnPO_ITEM_ID
POA_POD_BS_MV_N2 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnSUPPLIER_ID
ColumnSUPPLIER_SITE_ID
POA_POD_BS_MV_N3 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnBUYER_ID
POA_POD_BS_MV_N4 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Nested Grouping ID Column for Time
AGGREGATION_LEVEL NUMBER

Grouping ID Column
PERIOD_TYPE_ID NUMBER

Period Type Identifier
ORG_ID NUMBER

Operating Unit Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
CATEGORY_ID NUMBER

Category on the PO Line Identifier
PO_ITEM_ID NUMBER

Purchased Item Identifier
BUYER_ID NUMBER

Buyer Identifier
NEGOTIATION_CREATOR_ID NUMBER

Negotiation Creator Identifier
DOCTYPE_ID NUMBER

Negotiation Document Type Identifier
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
PURCHASE_AMT_B NUMBER

Purchase Amount in Functional Currency
PURCHASE_AMT_G NUMBER

Purchase Amount in Global Currency
PURCHASE_AMT_SG NUMBER

Purchase Amount in Secondary Global Currency
P_CONTRACT_AMT_B NUMBER

Contract Leakage Amount in Functional Currency
P_CONTRACT_AMT_G NUMBER

Contract Leakage Amount in Global Currency
P_CONTRACT_AMT_SG NUMBER

Contract Leakage Amount in Secondary Global Currency
N_CONTRACT_AMT_B NUMBER

Non-Contract Amount in Functional Currency
N_CONTRACT_AMT_G NUMBER

Non-Contract Amount in Global Currency
N_CONTRACT_AMT_SG NUMBER

Non-Contract Amount in Secondary Global Currency
P_SAVINGS_AMT_B NUMBER

Potential Savings Amount in Functional Currency
P_SAVINGS_AMT_G NUMBER

Potential Savings Amount in Global Currency
P_SAVINGS_AMT_SG NUMBER

Potential Savings Amount in Secondary Global Currency
NEG_PURCHASE_AMT_B NUMBER

Negotiated Purchases Amount in Functional Currency
NEG_PURCHASE_AMT_G NUMBER

Negotiated Purchases Amount in Global Currency
NEG_PURCHASE_AMT_SG NUMBER

Negotiated Purchases Amount in Secondary Global Currency
CURRENT_AMT_B NUMBER

Negotiation Amount at Current Price in Functional Currency
CURRENT_AMT_G NUMBER

Negotiation Amount at Current Price in Global Currency
CURRENT_AMT_SG NUMBER

Negotiation Amount at Current Price in Secondary Global Currency
REAL_SVNGS_AMT_B NUMBER

Realized Savings Amount in Functional Currency
REAL_SVNGS_AMT_G NUMBER

Realized Savings Amount in Global Currency
REAL_SVNGS_AMT_SG NUMBER

Realized Savings Amount in Secondary Global Currency
QUANTITY NUMBER

Quantity in Base UOM
CONTRACT_AMT_B NUMBER

Contract Amount in Functional Currency
CONTRACT_AMT_G NUMBER

Contract Amount in Global Currency
CONTRACT_AMT_SG NUMBER

Contract Amount in secondary Global Currency
ABOVE_CONTRACT_AMT_B NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Function Currency.
ABOVE_CONTRACT_AMT_G NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Global Currency.
ABOVE_CONTRACT_AMT_SG NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in secondary Global Currency.
BELOW_CONTRACT_AMT_B NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Functional Currency.
BELOW_CONTRACT_AMT_G NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Global Currency.
BELOW_CONTRACT_AMT_SG NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Secondary Global Currency.
NZ_QUANTITY NUMBER

Non Zero Quantity
C_PURCHASE_AMT_B NUMBER

Count Columns
C_PURCHASE_AMT_G NUMBER

Count Columns
C_PURCHASE_AMT_SG NUMBER

Count Columns
C_P_CONTRACT_AMT_B NUMBER

Count Columns
C_P_CONTRACT_AMT_G NUMBER

Count Columns
C_P_CONTRACT_AMT_SG NUMBER

Count Columns
C_N_CONTRACT_AMT_B NUMBER

Count Columns
C_N_CONTRACT_AMT_G NUMBER

Count Columns
C_N_CONTRACT_AMT_SG NUMBER

Count Columns
C_P_SAVINGS_AMT_B NUMBER

Count Columns
C_P_SAVINGS_AMT_G NUMBER

Count Columns
C_P_SAVINGS_AMT_SG NUMBER

Count Columns
C_NEG_PURCHASE_AMT_B NUMBER

Count column for Negotiated Purchases Amount in Functional Currency
C_NEG_PURCHASE_AMT_G NUMBER

Count column for Negotiated Purchases Amount in Global Currency
C_NEG_PURCHASE_AMT_SG NUMBER

Count column for Negotiated Purchases Amount in Secondary Global Currency
C_REAL_SVNGS_AMT_B NUMBER

Count column for Realized Savings Amount in Functional Currency
C_REAL_SVNGS_AMT_G NUMBER

Count column for Realized Savings Amount in Global Currency
C_REAL_SVNGS_AMT_SG NUMBER

Count column for Realized Savings Amount in Secondary Global Currency
C_TOTAL NUMBER

Row Count
COMMODITY_ID NUMBER

Commodity Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
C_QUANTITY NUMBER

Count Columns
C_CONTRACT_AMT_B NUMBER

Count Columns
C_CONTRACT_AMT_G NUMBER

Count Columns
C_CONTRACT_AMT_SG NUMBER

Count Columns
C_ABOVE_CONTRACT_AMT_B NUMBER

Count Columns
C_ABOVE_CONTRACT_AMT_G NUMBER

Count Columns
C_ABOVE_CONTRACT_AMT_SG NUMBER

Count Columns
C_BELOW_CONTRACT_AMT_B NUMBER

Count Columns
C_BELOW_CONTRACT_AMT_G NUMBER

Count Columns
C_BELOW_CONTRACT_AMT_SG NUMBER

Count Columns
C_NZ_QUANTITY NUMBER

Count Columns
C_CURRENT_AMT_B NUMBER

Count column for Negotiation Amount at Current Price in Functional Currency
C_CURRENT_AMT_G NUMBER

Count column for Negotiation Amount at Current Price in Global Currency
C_CURRENT_AMT_SG NUMBER

Count column for Negotiation Amount at Current Price in Secondary Global Currency
CONTRACT_TYPE NUMBER

1 for Blkt Releases, 2 for Scheduled Releases, 3 for PO referencing Global Agrmt, 4 for PO with Negotiated Pricing
Query Text

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


SELECT GRP_ID
,      TIME_ID
,      AGGREGATION_LEVEL
,      PERIOD_TYPE_ID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BUYER_ID
,      NEGOTIATION_CREATOR_ID
,      DOCTYPE_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      PURCHASE_AMT_B
,      PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      P_CONTRACT_AMT_B
,      P_CONTRACT_AMT_G
,      P_CONTRACT_AMT_SG
,      N_CONTRACT_AMT_B
,      N_CONTRACT_AMT_G
,      N_CONTRACT_AMT_SG
,      P_SAVINGS_AMT_B
,      P_SAVINGS_AMT_G
,      P_SAVINGS_AMT_SG
,      NEG_PURCHASE_AMT_B
,      NEG_PURCHASE_AMT_G
,      NEG_PURCHASE_AMT_SG
,      CURRENT_AMT_B
,      CURRENT_AMT_G
,      CURRENT_AMT_SG
,      REAL_SVNGS_AMT_B
,      REAL_SVNGS_AMT_G
,      REAL_SVNGS_AMT_SG
,      QUANTITY
,      CONTRACT_AMT_B
,      CONTRACT_AMT_G
,      CONTRACT_AMT_SG
,      ABOVE_CONTRACT_AMT_B
,      ABOVE_CONTRACT_AMT_G
,      ABOVE_CONTRACT_AMT_SG
,      BELOW_CONTRACT_AMT_B
,      BELOW_CONTRACT_AMT_G
,      BELOW_CONTRACT_AMT_SG
,      NZ_QUANTITY
,      C_PURCHASE_AMT_B
,      C_PURCHASE_AMT_G
,      C_PURCHASE_AMT_SG
,      C_P_CONTRACT_AMT_B
,      C_P_CONTRACT_AMT_G
,      C_P_CONTRACT_AMT_SG
,      C_N_CONTRACT_AMT_B
,      C_N_CONTRACT_AMT_G
,      C_N_CONTRACT_AMT_SG
,      C_P_SAVINGS_AMT_B
,      C_P_SAVINGS_AMT_G
,      C_P_SAVINGS_AMT_SG
,      C_NEG_PURCHASE_AMT_B
,      C_NEG_PURCHASE_AMT_G
,      C_NEG_PURCHASE_AMT_SG
,      C_REAL_SVNGS_AMT_B
,      C_REAL_SVNGS_AMT_G
,      C_REAL_SVNGS_AMT_SG
,      C_TOTAL
,      COMMODITY_ID
,      BASE_UOM
,      C_QUANTITY
,      C_CONTRACT_AMT_B
,      C_CONTRACT_AMT_G
,      C_CONTRACT_AMT_SG
,      C_ABOVE_CONTRACT_AMT_B
,      C_ABOVE_CONTRACT_AMT_G
,      C_ABOVE_CONTRACT_AMT_SG
,      C_BELOW_CONTRACT_AMT_B
,      C_BELOW_CONTRACT_AMT_G
,      C_BELOW_CONTRACT_AMT_SG
,      C_NZ_QUANTITY
,      C_CURRENT_AMT_B
,      C_CURRENT_AMT_G
,      C_CURRENT_AMT_SG
,      CONTRACT_TYPE
FROM APPS.POA_POD_BS_MV;

Dependencies

[top of page]

APPS.POA_POD_BS_MV does not reference any database object

APPS.POA_POD_BS_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_POD_BS_MV