VIEW: PON.PON_BID_SHIPMENTS_INT#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, AUCTION_HEADER_ID AUCTION_HEADER_ID, LINE_NUMBER LINE_NUMBER, BID_NUMBER BID_NUMBER, AUCTION_SHIPMENT_NUMBER AUCTION_SHIPMENT_NUMBER, BID_SHIPMENT_NUMBER BID_SHIPMENT_NUMBER, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, QUANTITY QUANTITY, PRICE_TYPE PRICE_TYPE, PRICE_DISCOUNT PRICE_DISCOUNT, BID_CURRENCY_UNIT_PRICE BID_CURRENCY_UNIT_PRICE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ACTION ACTION, WORKSHEET_NAME WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER, 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, MAX_QUANTITY MAX_QUANTITY from "PON"."PON_BID_SHIPMENTS_INT"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, LINE_NUMBER LINE_NUMBER
, BID_NUMBER BID_NUMBER
, AUCTION_SHIPMENT_NUMBER AUCTION_SHIPMENT_NUMBER
, BID_SHIPMENT_NUMBER BID_SHIPMENT_NUMBER
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, QUANTITY QUANTITY
, PRICE_TYPE PRICE_TYPE
, PRICE_DISCOUNT PRICE_DISCOUNT
, BID_CURRENCY_UNIT_PRICE BID_CURRENCY_UNIT_PRICE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ACTION ACTION
, WORKSHEET_NAME WORKSHEET_NAME
, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER
, 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
, MAX_QUANTITY MAX_QUANTITY
FROM "PON"."PON_BID_SHIPMENTS_INT"