VIEW: GML.OP_PRSL_AUD#

Source

View Text - Preformatted

select CHANGEPRSL_LINE_ID CHANGEPRSL_LINE_ID, PRICEREAS_CODE PRICEREAS_CODE, CHANGEPRSL_ID CHANGEPRSL_ID, NET_PRICE NET_PRICE, CHANGE_COMMENT CHANGE_COMMENT, ORDER_QTY1 ORDER_QTY1, BSO_MINTOTALQTY1 BSO_MINTOTALQTY1, BSO_MAXTOTALQTY1 BSO_MAXTOTALQTY1, BSO_MINTOTALVALUE BSO_MINTOTALVALUE, BSO_MAXTOTALVALUE BSO_MAXTOTALVALUE, ORDER_UM1 ORDER_UM1, AVAILABILITY_LEADTIME AVAILABILITY_LEADTIME, TRANSIT_LEADTIME TRANSIT_LEADTIME, QC_GRADE_WANTED QC_GRADE_WANTED, SHIPPER_CODE SHIPPER_CODE, SHIPCUST_ID SHIPCUST_ID, SHIPADDR_ID SHIPADDR_ID, TO_WHSE TO_WHSE, FROM_WHSE FROM_WHSE, PRESALES_ORDLINE_ID PRESALES_ORDLINE_ID, STATUS_IND STATUS_IND, 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, DELETE_MARK DELETE_MARK from "GML"."OP_PRSL_AUD"

View Text - HTML Formatted

SELECT CHANGEPRSL_LINE_ID CHANGEPRSL_LINE_ID
, PRICEREAS_CODE PRICEREAS_CODE
, CHANGEPRSL_ID CHANGEPRSL_ID
, NET_PRICE NET_PRICE
, CHANGE_COMMENT CHANGE_COMMENT
, ORDER_QTY1 ORDER_QTY1
, BSO_MINTOTALQTY1 BSO_MINTOTALQTY1
, BSO_MAXTOTALQTY1 BSO_MAXTOTALQTY1
, BSO_MINTOTALVALUE BSO_MINTOTALVALUE
, BSO_MAXTOTALVALUE BSO_MAXTOTALVALUE
, ORDER_UM1 ORDER_UM1
, AVAILABILITY_LEADTIME AVAILABILITY_LEADTIME
, TRANSIT_LEADTIME TRANSIT_LEADTIME
, QC_GRADE_WANTED QC_GRADE_WANTED
, SHIPPER_CODE SHIPPER_CODE
, SHIPCUST_ID SHIPCUST_ID
, SHIPADDR_ID SHIPADDR_ID
, TO_WHSE TO_WHSE
, FROM_WHSE FROM_WHSE
, PRESALES_ORDLINE_ID PRESALES_ORDLINE_ID
, STATUS_IND STATUS_IND
, 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
, DELETE_MARK DELETE_MARK
FROM "GML"."OP_PRSL_AUD"