[Home] [Help] [Dependency Information]
Object Name: | POA_DBI_NEG_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | POA |
Subobject Name: | |
Status: | VALID |
Table that stores Negotiation Details for a PO Distribution
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
POA_DBI_NEG_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | PO_DISTRIBUTION_ID |
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 |
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;
POA.POA_DBI_NEG_DETAILS does not reference any database object
POA.POA_DBI_NEG_DETAILS is referenced by following:
|
|
|