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


MATERIALIZED VIEW: APPS.POA_NEG_001_MV

Object Details
Object Name: POA_NEG_001_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: POA_NEG_001_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_NEG_000_MV
     FII_TIME_DAY
     POA_DBI_NEG_F
     PO_COMMODITY_CATEGORIES

[View Source Query]

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 references the following:

SchemaAPPS
TablePOA_NEG_000_MV
Materialized ViewPOA_NEG_000_MV
TablePOA_NEG_001_MV

APPS.POA_NEG_001_MV is not referenced by any database object