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

TABLE: PON.PON_BID_SHIPMENTS

Object Details
Object Name: PON_BID_SHIPMENTS
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_BID_SHIPMENTS
Subobject Name:
Status: VALID


PON_BID_SHIPMENTS stores responses' shipment information (for now, limited to price breaks).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_BID_SHIPMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBID_NUMBER
ColumnLINE_NUMBER
ColumnSHIPMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
BID_NUMBER NUMBER
Yes Unique Bid Number
LINE_NUMBER NUMBER
Yes Bid Line Number
SHIPMENT_NUMBER NUMBER
Yes Bid Shipment Number
AUCTION_HEADER_ID NUMBER
Yes Auction Header Id
AUCTION_LINE_NUMBER NUMBER
Yes Auction Line Number
AUCTION_SHIPMENT_NUMBER NUMBER

Auction Shipment Number
SHIPMENT_TYPE VARCHAR2 (25)
Type of shipment
SHIP_TO_ORGANIZATION_ID NUMBER

Ship-to Organization Id
SHIP_TO_LOCATION_ID NUMBER

Ship-to Location Id
QUANTITY NUMBER

Shipment Quantity
PRICE_TYPE VARCHAR2 (25)
Type of Shipment Price
PRICE NUMBER

Shipment Price
BID_CURRENCY_PRICE NUMBER

Shipment Bid Currency Price
PRICE_DISCOUNT NUMBER

Shipment Price Discount
EFFECTIVE_START_DATE DATE

Effective Start Date
EFFECTIVE_END_DATE DATE

Effective End Date
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
HAS_PRICE_DIFFERENTIALS_FLAG VARCHAR2 (1) Yes Flag to indicate if the response shipment has price differentials
UNIT_PRICE NUMBER

Stores value entered by supplier in auction currency
BID_CURRENCY_UNIT_PRICE NUMBER

Stores value entered by supplier in bid currency.
OLD_BID_CURRENCY_UNIT_PRICE NUMBER

Unit price in bid currency for source bid
OLD_BID_CURRENCY_PRICE NUMBER

Total price in bid currency from source bid.
OLD_PRICE_DISCOUNT NUMBER

Price discount from source bid.
OLD_SHIP_TO_ORG_ID NUMBER

Ship to organization id from source bid.
OLD_SHIP_TO_LOC_ID NUMBER

Ship to location id from source bid.
OLD_EFFECTIVE_START_DATE DATE

Effective start date from source bid.
OLD_EFFECTIVE_END_DATE DATE

Effective end date from source bid.
OLD_QUANTITY NUMBER

Quantity from source bid.
OLD_PRICE_TYPE VARCHAR2 (25)
Price type from source bid.
MAX_QUANTITY NUMBER

Stores the Maximum Quantity for Quantity Tiers
PER_UNIT_PRICE_COMPONENT NUMBER

Contains the per unit price minus Fixed amount components
INTERFACE_LINE_ID NUMBER

Interface Line ID
OLD_MAX_QUANTITY NUMBER

Max quantity of the previous bid
Query Text

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


SELECT BID_NUMBER
,      LINE_NUMBER
,      SHIPMENT_NUMBER
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      AUCTION_SHIPMENT_NUMBER
,      SHIPMENT_TYPE
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_LOCATION_ID
,      QUANTITY
,      PRICE_TYPE
,      PRICE
,      BID_CURRENCY_PRICE
,      PRICE_DISCOUNT
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      HAS_PRICE_DIFFERENTIALS_FLAG
,      UNIT_PRICE
,      BID_CURRENCY_UNIT_PRICE
,      OLD_BID_CURRENCY_UNIT_PRICE
,      OLD_BID_CURRENCY_PRICE
,      OLD_PRICE_DISCOUNT
,      OLD_SHIP_TO_ORG_ID
,      OLD_SHIP_TO_LOC_ID
,      OLD_EFFECTIVE_START_DATE
,      OLD_EFFECTIVE_END_DATE
,      OLD_QUANTITY
,      OLD_PRICE_TYPE
,      MAX_QUANTITY
,      PER_UNIT_PRICE_COMPONENT
,      INTERFACE_LINE_ID
,      OLD_MAX_QUANTITY
FROM PON.PON_BID_SHIPMENTS;

Dependencies

[top of page]

PON.PON_BID_SHIPMENTS does not reference any database object

PON.PON_BID_SHIPMENTS is referenced by following:

SchemaPON
ViewPON_BID_SHIPMENTS#