Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT MODIFIER_NAME||HTMLDB_ITEM.HIDDEN(1,QUOTE_PRICE_BREAK_ID) MODIFIER_NAME,
- MAX(PRICE_LIST_NAME) OVER () PRICE_LIST_NAME,
- HTMLDB_ITEM.TEXT(2,FROM_QTY,6,NULL,'style="text-align:right;"') FROM_QTY,
- HTMLDB_ITEM.TEXT(3,PRICE,6,NULL,'style="text-align:right;"') PRICE,
- spep_htmldb_utils.checkbox(4,USE) USE,
- spep_htmldb_utils.checkbox(5,INITIAL_ORDER_FLAG) INITIAL_ORDER_FLAG,
- QUOTE_PRICE_BREAK_ID,
- QUOTE_LINE_ID,
- CREATION_DATE,
- CREATED_BY,
- LAST_UPDATE_DATE,
- LAST_UPDATED_BY,
- HTMLDB_ITEM.CHECKBOX(6, QUOTE_PRICE_BREAK_ID) "Delete",
- FROM_QTY FROM_QTY_sort
- FROM C3_QUOTE_LINE_PRICE_BREAKS
- WHERE QUOTE_LINE_ID = :P10_QUOTE_LINE_ID
- ORDER BY FROM_QTY_sort
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement