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]

VIEW: APPS.POA_DBI_NEG_F_V

Object Details

Object Name:	POA_DBI_NEG_F_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View based on Negotiations Fact and commodity assignment table

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID	NUMBER		Yes	Auction Header Id
AUCTION_LINE_NUMBER	NUMBER			Auction Line Number
BID_NUMBER	NUMBER			Bid Number
BID_LINE_NUMBER	NUMBER			Bid Line Number
AWARD_QTY	NUMBER			Award Quantity
AWARD_AMOUNT_B	NUMBER			Award Amount in Functional Currency
AWARD_AMOUNT_G	NUMBER			Award Amount in Global Currency
AWARD_AMOUNT_SG	NUMBER			Award Amount in Secondary Global Currency
PO_HEADER_ID	NUMBER			PO Header Id
AUCTION_CREATION_DATE	DATE			Auction Creation Date
AWARD_COMPLETE_DATE	DATE			Award Complete Date
RFI_COMPLETE_DATE	DATE			RFI (Request For Information) Complete Date
AWARD_STATUS	VARCHAR2	(25)		Award Status
CONTRACT_TYPE	VARCHAR2	(25)		Contract Type
ORG_ID	NUMBER			Operating Unit Id
COMMODITY_ID	NUMBER		Yes	Commodity Id
CATEGORY_ID	NUMBER			Category Id
SUPPLIER_ID	NUMBER			Supplier Id
SUPPLIER_SITE_ID	NUMBER			Supplier Site Id
PO_ITEM_ID	NUMBER			PO Item Id
BASE_UOM	VARCHAR2	(25)		Base Unit of Measure
NEGOTIATION_CREATOR_ID	NUMBER			Negotiation Creator Id
DOCTYPE_ID	NUMBER			Document Type Id

Query Text

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


SELECT AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      AWARD_QTY
,      AWARD_AMOUNT_B
,      AWARD_AMOUNT_G
,      AWARD_AMOUNT_SG
,      PO_HEADER_ID
,      AUCTION_CREATION_DATE
,      AWARD_COMPLETE_DATE
,      RFI_COMPLETE_DATE
,      AWARD_STATUS
,      CONTRACT_TYPE
,      ORG_ID
,      COMMODITY_ID
,      CATEGORY_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      PO_ITEM_ID
,      BASE_UOM
,      NEGOTIATION_CREATOR_ID
,      DOCTYPE_ID
FROM APPS.POA_DBI_NEG_F_V;

Dependencies

[top of page]

APPS.POA_DBI_NEG_F_V references the following:

APPS: POA_DBI_NEG_F; PO_COMMODITY_CATEGORIES

APPS.POA_DBI_NEG_F_V is not referenced by any database object