|
There is 0 item(s) in your cart.
|
inv_cur_key=;CustomerKey=00000000-0000-0000-0000-000000000000;listwhere=; pager=12
SELECT prd_key,
prd_name,
[isbn] = ISNULL(pub_isbn_number, ''),
[description] = substring(prd_description,0, 200),
[descMoreLinkText] = case when substring(prd_description,0, 200) != convert(nvarchar(210),prd_description) then 'more»' else '' end,
[newIcon] = case when prd_show_as_new_until is not null and prd_show_as_new_until > dbo.nf_get_date() then 'New' else '' end,
[productURL] = 'DynamicPage.aspx?Action=Add&ObjectKeyFrom=1A83491A-9853-4C87-86A4-F7D95601C2E2&WebCode=ProdDetailAdd&DoNotSave=yes&ParentObject=CentralizedOrderEntry&ParentDataObject=Invoice Detail&ivd_formkey=69202792-63d7-4ba2-bf4e-a0da41270555&ivd_cst_key=' + convert(varchar(50),00000000-0000-0000-0000-000000000000) + '&ivd_cst_ship_key=' + convert(varchar(50),00000000-0000-0000-0000-000000000000) + '&ivd_prc_prd_key=' + convert(varchar(50),prd_key),
[productImage] = case when doc_url is not null then doc_url else 'images/DEMO1/notavailable.jpg' end,
[qtyAvailable] = case when prd_track_inventory_flag = 1 then convert(nvarchar(50),Convert(int,ivw_qty_available)) else '' end,
[outOfStockMessage] = case when prd_track_inventory_flag = 1 and ivw_qty_available < 1 and prd_allow_backorder !=1 THEN isnull(prd_out_of_stock_override_message, 'Out of stock') ELSE '' END,
[backOrderMessage] = case when prd_track_inventory_flag = 1 and ivw_qty_available < 1 and prd_allow_backorder = 1 THEN isnull(prd_out_of_stock_override_message, 'Item ON backorder') ELSE '' END,
[ShowWishList] = case when cwl_key is null and cst_type = 'Individual' then '1' else '0' end,
[addToWishListURL] = 'DynamicPage.aspx?ObjectKeyFrom=1A83491A-9853-4C87-86A4-F7D95601C2E2&WebCode=CSCAddToWishList&DoNotSave=yes&ParentObject=CentralizedOrderEntry&ParentDataObject=Invoice Detail&ivd_formkey=69202792-63d7-4ba2-bf4e-a0da41270555&ivd_cst_key=' + convert(varchar(50),'00000000-0000-0000-0000-000000000000') + '&ivd_prc_prd_key=' + convert(varchar(50),prd_key),
[addToWishListButton] = '',
[addToCartButton] = case when prd_track_inventory_flag = 1 and ivw_qty_available < 1 and prd_allow_backorder !=1 then '' else '' end,
[AvgRating] = case when vcr_rating = 0 then '???' else str(vcr_rating,3,1) end,
[PurchaseCstKey] = case when vpr_cpr_key is null then vpr_cst_key else null end
from oe_product (nolock)
join oe_product_type ptp (nolock) on ptp.ptp_key = prd_ptp_key
join co_customer (nolock) on cst_key =
left join oe_publication (nolock) on pub_prd_key = prd_key
left join co_document (nolock) on prd_thumbnail_doc_key = doc_key
left join oe_merchandise (nolock) on mer_prd_key=prd_key
left join oe_product_kit (nolock) ON kit_prd_key=prd_key
left join oe_product_category (nolock) on ptc_key = prd_ptc_key
left join co_customer_wish_list (nolock) on cwl_prd_key=prd_key and cwl_ind_cst_key=
left join vw_oe_product_purchases (nolock) on vpr_prd_key = prd_key and vpr_cst_key =
left join vw_co_customer_product_rating (nolock) on vcr_prd_key = prd_key
left join (select ivw_prd_key, sum(ivw_qty_available_cp) as ivw_qty_available from oe_inventory_x_warehouse (nolock)
group by ivw_prd_key) as ivw_prd_available_qty on prd_key = ivw_prd_key
where prd_delete_flag = 0
and prd_sell_online = 1
and ((prd_start_date < dbo.nf_get_date() or prd_start_date is null)
and (prd_end_date+1 > dbo.nf_get_date() or prd_end_date is null))
and (ptp_code = 'Publication')
and (mer_delete_flag is null or mer_delete_flag=0)
and (kit_delete_flag is null or kit_delete_flag=0)
and prd_key in (select prc_prd_key from oe_price
where prc_prd_key = prd_key and prc_sell_online = 1
and (false='false' or prc_cur_key is null or isnull(,prc_cur_key)=prc_cur_key ))
and ( is null or prd_name like '%'++'%')
order by prd_name
SELECT [price] =
case when
EXISTS(SELECT pat_member_flag FROM oe_price_attribute WHERE pat_prc_key = prc_key AND pat_member_flag = 1)
then
'<span class="price" title="Member Price"> ' +
case when false='true'
then
convert(nvarchar(50),dbo.av_format_currency(prc_price ,isnull(prc_cur_key,cc.cur_key)))
else
'$' + convert(nvarchar(50),prc_price)
end
+ '</span>'
else
'<span class="price muted">$' +
case when
false='true'
then
convert(nvarchar(50),dbo.av_format_currency(prc_price ,isnull(prc_cur_key,cc.cur_key)))
else
convert(nvarchar(50),prc_price)
end
+ '</span>'
end
from oe_price (nolock)
join oe_product (nolock) on prd_key = prc_prd_key
join ac_company (nolock) on prd_atc_key=atc_key
left join ac_currency pc (nolock) on prc_cur_key=pc.cur_key
left join ac_currency (nolock) cc on cc.cur_code=isnull(atc_currency_code,'USD')
where prc_sell_online = 1
and prc_delete_flag = 0
and ((prc_start_date < dbo.nf_get_date() or prc_start_date is null)
and (prc_end_date > dbo.nf_get_date() or prc_end_date is null))
and prd_key =
and (false='false' or prc_cur_key is null or isnull(,prc_cur_key)=prc_cur_key )
order by price
12
prd_name
publications-pager-bookmark
Publications
Show Per Page
/
|
Search Publications (Enter a keyword, publication name or description): |
|
|
|
|
|