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

TABLE: POA.POA_DBI_NEG_DETAILS

Object Details
Object Name: POA_DBI_NEG_DETAILS
Object Type: TABLE
Owner: POA
Subobject Name:
Status: VALID


Table that stores Negotiation Details for a PO Distribution


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POA_DBI_NEG_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnPO_DISTRIBUTION_ID
Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Yes PO Distribution Identifier
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
NEGOTIATION_CREATOR_ID NUMBER

Negotiation Creator Identifier
DOCTYPE_ID NUMBER

Document Type Identifier
NEG_CURRENT_PRICE NUMBER

Current Price
NEG_FUNC_CUR_CODE VARCHAR2 (15)
Functional Currency Code
NEG_FUNC_CUR_CONV_RATE NUMBER

Functional Currency Conversion Rate
NEG_GLOBAL_CUR_CONV_RATE NUMBER

Global Currency Conversion Rate
NEG_SGLOBAL_CUR_CONV_RATE NUMBER

Secondary Global Currency Conversion Rate
NEG_TRANSACTION_UOM VARCHAR2 (25)
Transaction UOM
NEG_BASE_UOM VARCHAR2 (25)
Base UOM
NEG_BASE_UOM_CONV_RATE NUMBER

Conversion Rate from Transaction UOM to Base UOM
Query Text

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


SELECT PO_DISTRIBUTION_ID
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      NEGOTIATION_CREATOR_ID
,      DOCTYPE_ID
,      NEG_CURRENT_PRICE
,      NEG_FUNC_CUR_CODE
,      NEG_FUNC_CUR_CONV_RATE
,      NEG_GLOBAL_CUR_CONV_RATE
,      NEG_SGLOBAL_CUR_CONV_RATE
,      NEG_TRANSACTION_UOM
,      NEG_BASE_UOM
,      NEG_BASE_UOM_CONV_RATE
FROM POA.POA_DBI_NEG_DETAILS;

Dependencies

[top of page]

POA.POA_DBI_NEG_DETAILS does not reference any database object

POA.POA_DBI_NEG_DETAILS is referenced by following:

SchemaAPPS
SynonymPOA_DBI_NEG_DETAILS