Advertisement
cgrunwald

Untitled

Jul 7th, 2012
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.73 KB | None | 0 0
  1. SELECT MODIFIER_NAME||HTMLDB_ITEM.HIDDEN(1,QUOTE_PRICE_BREAK_ID) MODIFIER_NAME,
  2.        MAX(PRICE_LIST_NAME) OVER () PRICE_LIST_NAME,
  3.        HTMLDB_ITEM.TEXT(2,FROM_QTY,6,NULL,'style="text-align:right;"') FROM_QTY,
  4.        HTMLDB_ITEM.TEXT(3,PRICE,6,NULL,'style="text-align:right;"') PRICE,
  5.        spep_htmldb_utils.checkbox(4,USE) USE,
  6.        spep_htmldb_utils.checkbox(5,INITIAL_ORDER_FLAG) INITIAL_ORDER_FLAG,
  7.        QUOTE_PRICE_BREAK_ID,
  8.        QUOTE_LINE_ID,
  9.        CREATION_DATE,
  10.        CREATED_BY,
  11.        LAST_UPDATE_DATE,
  12.        LAST_UPDATED_BY,
  13.        HTMLDB_ITEM.CHECKBOX(6, QUOTE_PRICE_BREAK_ID) "Delete",
  14. FROM_QTY FROM_QTY_sort
  15. FROM   C3_QUOTE_LINE_PRICE_BREAKS
  16. WHERE  QUOTE_LINE_ID = :P10_QUOTE_LINE_ID
  17. ORDER BY FROM_QTY_sort
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement