eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

MATERIALIZED VIEW: APPS.POA_NEG_000_MV

Object Details

Object Name:	POA_NEG_000_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	POA_NEG_000_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	TEXTMATCH
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


FII_TIME_DAY
POA_DBI_NEG_F
PO_COMMODITY_CATEGORIES

[View Source Query]

Columns

Name	Datatype	Length	Comments
UMARKER	NUMBER		Union Marker
CRID	ROWID	(10)	Row Identifier for Time Dimension
COMRID	ROWID	(10)	Row Identifier for Commodity Dimension
FRID	ROWID	(10)	Row Identifier for Negotiations Fact
ENT_YEAR_ID	NUMBER		Enterprise Year 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
AUCTION_HEADER_ID	NUMBER		Negotiation Header Identifier
AUCTION_LINE_NUMBER	NUMBER		Negotiation Line Number
BID_NUMBER	NUMBER		Negotiation Bid Number
BID_LINE_NUMBER	NUMBER		Negotiation Bid Line Number
PO_HEADER_ID	NUMBER		PO Header Identifier
DOCTYPE_ID	NUMBER		Negotiation document type Identifier
AUCTION_ROUND_NUMBER	NUMBER		Negotiation Round Number
AUCTION_CREATION_DATE	DATE		Negotiation Creation Date
PUBLISH_DATE	DATE		Negotiation Publish Date
OPEN_BIDDING_DATE	DATE		Negotiation Opened for Bidding Date
CLOSE_BIDDING_DATE	DATE		Negotiation Closed for Bidding Date
PREV_ROUND_CLOSE_DATE	DATE		Negotiation Previous Round Close Date
NEXT_ROUND_CREATION_DATE	DATE		Negotiation Next Round Creation Date
AWARD_DATE	DATE		Negotiation Award Date
AWARD_COMPLETE_DATE	DATE		Negotiation Award Complete Date
RFI_COMPLETE_DATE	DATE		RFI Complete Date
ORG_ID	NUMBER		Operating Unit Identifier
COMMODITY_ID	NUMBER		Commodity Identifier
NEGOTIATION_CREATOR_ID	NUMBER		Negotiation Creator Identifier
CATEGORY_ID	NUMBER		Category Identifier
PO_ITEM_ID	NUMBER		PO Item Identifier
SUPPLIER_ID	NUMBER		Supplier Identifier
SUPPLIER_SITE_ID	NUMBER		Supplier Site Identifier
QUANTITY	NUMBER		Quantity Specified in Negotiation
AWARD_QTY	NUMBER		Awarded Quantity
AWARD_PRICE	NUMBER		Awarded Price
CURRENT_PRICE	NUMBER		Current Price of Item at the beginning of Negotiation
AWARD_AMOUNT_T	NUMBER		Awarded Amount in Transactional Currency
AWARD_AMOUNT_B	NUMBER		Awarded Amount in Functional Currency
AWARD_AMOUNT_G	NUMBER		Awarded Amount in Global Currency
AWARD_AMOUNT_SG	NUMBER		Awarded Amount in Secondary Global Currency
CURRENT_AMOUNT_T	NUMBER		Current Amount in Transactional Currency
CURRENT_AMOUNT_B	NUMBER		Current Amount in Functional Currency
CURRENT_AMOUNT_G	NUMBER		Current Amount in Global Currency
CURRENT_AMOUNT_SG	NUMBER		Current Amount in Secondary Global Currency
AUCTION_STATUS	VARCHAR2	(25)	Negotiation Status
AWARD_STATUS	VARCHAR2	(25)	Negotiation Award Status
ALLOCATION_STATUS	VARCHAR2	(30)	Negotiation Allocation Status
SUPPLIER_INVITE_DATE	DATE		Date on which the Awarded Supplier was invited
BASE_UOM	VARCHAR2	(25)	Base Unit of Measure
CONTRACT_TYPE	VARCHAR2	(25)	Negotiation Outcome Document

Query Text

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


SELECT UMARKER
,      CRID
,      COMRID
,      FRID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      PO_HEADER_ID
,      DOCTYPE_ID
,      AUCTION_ROUND_NUMBER
,      AUCTION_CREATION_DATE
,      PUBLISH_DATE
,      OPEN_BIDDING_DATE
,      CLOSE_BIDDING_DATE
,      PREV_ROUND_CLOSE_DATE
,      NEXT_ROUND_CREATION_DATE
,      AWARD_DATE
,      AWARD_COMPLETE_DATE
,      RFI_COMPLETE_DATE
,      ORG_ID
,      COMMODITY_ID
,      NEGOTIATION_CREATOR_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      QUANTITY
,      AWARD_QTY
,      AWARD_PRICE
,      CURRENT_PRICE
,      AWARD_AMOUNT_T
,      AWARD_AMOUNT_B
,      AWARD_AMOUNT_G
,      AWARD_AMOUNT_SG
,      CURRENT_AMOUNT_T
,      CURRENT_AMOUNT_B
,      CURRENT_AMOUNT_G
,      CURRENT_AMOUNT_SG
,      AUCTION_STATUS
,      AWARD_STATUS
,      ALLOCATION_STATUS
,      SUPPLIER_INVITE_DATE
,      BASE_UOM
,      CONTRACT_TYPE
FROM APPS.POA_NEG_000_MV;

Dependencies

[top of page]

APPS.POA_NEG_000_MV references the following:

APPS: POA_NEG_000_MV
FII: FII_TIME_DAY
PO: PO_COMMODITY_CATEGORIES
POA: POA_DBI_NEG_F

APPS.POA_NEG_000_MV is referenced by following:

APPS: POA_NEG_001_MV