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

TABLE: APPS.POA_NEG_001_MV

Object Details
Object Name: POA_NEG_001_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.POA_NEG_001_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_POA_NEG_001_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("COMMODITY_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_ID")
ColumnSYS_OP_MAP_NONNULL("PO_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_SITE_ID")
ColumnSYS_OP_MAP_NONNULL("NEGOTIATION_CREATOR_ID")
ColumnSYS_OP_MAP_NONNULL("BASE_UOM")
ColumnSYS_OP_MAP_NONNULL("DOCTYPE_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_NEG_001_MV_N1 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnCATEGORY_ID
ColumnPO_ITEM_ID
POA_NEG_001_MV_N2 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnSUPPLIER_ID
ColumnORG_ID
POA_NEG_001_MV_N3 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnDOCTYPE_ID
ColumnNEGOTIATION_CREATOR_ID
Columns
Name Datatype Length Mandatory Comments
GRP_ID NUMBER

Grouping Identifier
TIME_ID NUMBER

Time Identifier
AGGREGATION_LEVEL NUMBER

Aggregation Level
ORG_ID NUMBER

Operating Unit Identifier
COMMODITY_ID NUMBER

Commodity Identifier
CATEGORY_ID NUMBER

Category Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
PO_ITEM_ID NUMBER

PO Item Identifier
NEGOTIATION_CREATOR_ID NUMBER

Negotiation Creator Identifier
BASE_UOM VARCHAR2 (25)
Base Unit of Measure
DOCTYPE_ID NUMBER

Negotiation Document Type Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

Week Identifier
DAY_ID NUMBER

Day Identifier
AWARD_QTY NUMBER

Award Quantity
AWARD_AMT_B NUMBER

Award Amount in Functional Currency
AWARD_AMT_G NUMBER

Award Amount in Global Currency
AWARD_AMT_SG NUMBER

Award Amount in Secondary Global Currency
CURRENT_AMT_B NUMBER

Amount calculated using Current Price in Functional Currency
CURRENT_AMT_G NUMBER

Amount calculated using Current Price in Global Currency
CURRENT_AMT_SG NUMBER

Amount calculated using Current Price in Secondary Global Currency
PROJ_SAVINGS_AMT_B NUMBER

Projected Savings Amount in Functional Currency
PROJ_SAVINGS_AMT_G NUMBER

Projected Savings Amount in Global Currency
PROJ_SAVINGS_AMT_SG NUMBER

Projected Savings Amount in Secondary Global Currency
PREPARATION_TIME NUMBER

Time taken for Negotiation Preparation
BIDDING_TIME NUMBER

Time taken for Negotiation Bidding
ANALYSIS_TIME NUMBER

Time taken for analysing the responses of Negotiation
AWARD_TIME NUMBER

Time taken to award a Negotiation
NEGOTIATED_LINES NUMBER

Total Negotiated Lines
NEG_LINES_WITH_CP NUMBER

Negotiated Lines with a valid Current Price
C_AWARD_QTY NUMBER

Count column for Award Quantity
C_AWARD_AMT_B NUMBER

Count column for Award Amount in Functional Currency
C_AWARD_AMT_G NUMBER

Count column for Award Amount in Global Currency
C_AWARD_AMT_SG NUMBER

Count column for Award Amount in Secondary Global Currency
C_CURRENT_AMT_B NUMBER

Count column for Amount calculated using Current Price in Functional Currency
C_CURRENT_AMT_G NUMBER

Count column for Amount calculated using Current Price in Global Currency
C_CURRENT_AMT_SG NUMBER

Count column for Amount calculated using Current Price in Secondary Global Currency
C_PROJ_SAVINGS_AMT_B NUMBER

Count column for Projected Savings Amount in Functional Currency
C_PROJ_SAVINGS_AMT_G NUMBER

Count column for Projected Savings Amount in Global Currency
C_PROJ_SAVINGS_AMT_SG NUMBER

Count column for Projected Savings Amount in Secondary Global Currency
C_PREPARATION_TIME NUMBER

Count column for Time taken for Negotiation Preparation
C_BIDDING_TIME NUMBER

Count column for Time taken for Negotiation Bidding
C_AWARD_TIME NUMBER

Count column for Time taken to award a Negotiation
C_ANALYSIS_TIME NUMBER

Count column for Time taken for analysing the responses of Negotiation
C_NEGOTIATED_LINES NUMBER

Count column for Total Negotiated Lines
C_NEG_LINES_WITH_CP NUMBER

Count column for Negotiated Lines with a valid Current Price
C_TOTAL NUMBER

Total Negotiation Lines including RFI documents
Query Text

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


SELECT GRP_ID
,      TIME_ID
,      AGGREGATION_LEVEL
,      ORG_ID
,      COMMODITY_ID
,      CATEGORY_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      PO_ITEM_ID
,      NEGOTIATION_CREATOR_ID
,      BASE_UOM
,      DOCTYPE_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AWARD_QTY
,      AWARD_AMT_B
,      AWARD_AMT_G
,      AWARD_AMT_SG
,      CURRENT_AMT_B
,      CURRENT_AMT_G
,      CURRENT_AMT_SG
,      PROJ_SAVINGS_AMT_B
,      PROJ_SAVINGS_AMT_G
,      PROJ_SAVINGS_AMT_SG
,      PREPARATION_TIME
,      BIDDING_TIME
,      ANALYSIS_TIME
,      AWARD_TIME
,      NEGOTIATED_LINES
,      NEG_LINES_WITH_CP
,      C_AWARD_QTY
,      C_AWARD_AMT_B
,      C_AWARD_AMT_G
,      C_AWARD_AMT_SG
,      C_CURRENT_AMT_B
,      C_CURRENT_AMT_G
,      C_CURRENT_AMT_SG
,      C_PROJ_SAVINGS_AMT_B
,      C_PROJ_SAVINGS_AMT_G
,      C_PROJ_SAVINGS_AMT_SG
,      C_PREPARATION_TIME
,      C_BIDDING_TIME
,      C_AWARD_TIME
,      C_ANALYSIS_TIME
,      C_NEGOTIATED_LINES
,      C_NEG_LINES_WITH_CP
,      C_TOTAL
FROM APPS.POA_NEG_001_MV;

Dependencies

[top of page]

APPS.POA_NEG_001_MV does not reference any database object

APPS.POA_NEG_001_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_NEG_001_MV