VIEW: PON.PON_BID_SHIPMENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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