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]

TABLE: POA.POA_DBI_NEG_F

Object Details

Object Name:	POA_DBI_NEG_F
Object Type:	TABLE
Owner:	POA
Subobject Name:
Status:	VALID

Negotiations base table for DBI - only update and insert are allowed.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POA_DBI_NEG_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	AUCTION_HEADER_ID NEGOTIATION_CREATOR_ID CATEGORY_ID PO_ITEM_ID
POA_DBI_NEG_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	AUCTION_HEADER_ID SUPPLIER_ID ORG_ID DOCTYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID	NUMBER		Yes	Auction Header Identifier
AUCTION_LINE_NUMBER	NUMBER			Auction Line Number
BID_NUMBER	NUMBER			Bid Number
BID_LINE_NUMBER	NUMBER			Bid Line Number
DOCTYPE_ID	NUMBER			Document Type Identifier
AUCTION_ROUND_NUMBER	NUMBER			Auction Round Number
PREV_ROUND_AUCTION_HEADER_ID	NUMBER			Previous Round Auction Header Identifier
AUCTION_CREATION_DATE	DATE			Negotiation Creation Date
PUBLISH_DATE	DATE			Negotiation Publish Date
OPEN_BIDDING_DATE	DATE			Open for Bidding Date
CLOSE_BIDDING_DATE	DATE			Closed for Bidding Date
PREV_ROUND_CLOSE_DATE	DATE			Previous Round Close Date
NEXT_ROUND_CREATION_DATE	DATE			Next Round Creation Date
AWARD_DATE	DATE			Award Date
AWARD_COMPLETE_DATE	DATE			Award Complete Date
RFI_COMPLETE_DATE	DATE			RFI Complete Date
ORG_ID	NUMBER			Operating Unit Identifier
NEGOTIATION_CREATOR_ID	NUMBER			Negotiation Creator Identifier
CATEGORY_ID	NUMBER			Category Identifier
PO_ITEM_ID	NUMBER			Item Identifier
SUPPLIER_ID	NUMBER			Supplier Identifier
SUPPLIER_SITE_ID	NUMBER			Supplier Site Identifier
QUANTITY	NUMBER			Quantity
AWARD_QTY	NUMBER			Awarded Quantity
AWARD_PRICE	NUMBER			Award Price
CURRENT_PRICE	NUMBER			Current Price
AWARD_AMOUNT_T	NUMBER			Award Amount in Transactional Currency
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
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
LINE_TYPE_ID	NUMBER			Line Type Identifier
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Order type lookup code
AUCTION_STATUS	VARCHAR2	(25)		Auction Status
AWARD_STATUS	VARCHAR2	(25)		Award Status
ALLOCATION_STATUS	VARCHAR2	(30)		Allocation Status
RECEIVED_BID_COUNT	NUMBER			Received Bid Count
SUPPLIER_INVITE_DATE	DATE			Supplier Invite Date
CONTRACT_TYPE	VARCHAR2	(25)		Contract Type
PO_HEADER_ID	NUMBER			PO Header Identifier
REQUISITION_HEADER_ID	NUMBER			Requisition Header Identifier
REQUISITION_LINE_ID	NUMBER			Requisition Line Identifier
FUNC_CUR_CODE	VARCHAR2	(15)		Functional Currency Code
FUNC_CUR_CONV_RATE	NUMBER			Functional Currency Conversion Rate
GLOBAL_CUR_CONV_RATE	NUMBER			Global Currency Conversion Rate
SGLOBAL_CUR_CONV_RATE	NUMBER			Secondary Global Currency Conversion Rate
BASE_UOM	VARCHAR2	(25)		Base UOM
TRANSACTION_UOM	VARCHAR2	(25)		Transaction UOM
BASE_UOM_CONV_RATE	NUMBER			Base UOM Conversion Rate
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column

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
,      DOCTYPE_ID
,      AUCTION_ROUND_NUMBER
,      PREV_ROUND_AUCTION_HEADER_ID
,      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
,      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
,      LINE_TYPE_ID
,      ORDER_TYPE_LOOKUP_CODE
,      AUCTION_STATUS
,      AWARD_STATUS
,      ALLOCATION_STATUS
,      RECEIVED_BID_COUNT
,      SUPPLIER_INVITE_DATE
,      CONTRACT_TYPE
,      PO_HEADER_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      FUNC_CUR_CODE
,      FUNC_CUR_CONV_RATE
,      GLOBAL_CUR_CONV_RATE
,      SGLOBAL_CUR_CONV_RATE
,      BASE_UOM
,      TRANSACTION_UOM
,      BASE_UOM_CONV_RATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM POA.POA_DBI_NEG_F;

Dependencies

[top of page]

POA.POA_DBI_NEG_F does not reference any database object

POA.POA_DBI_NEG_F is referenced by following:

APPS: POA_DBI_NEG_F; POA_NEG_000_MV