Вопросы про заказы поставщикам? : Супермаг Плюс (Супермаг 2000)

create or replace view svspecor as
Select DocType, DocID, SpecItem, Article, Quantity,
		ItemPrice, TotalPrice, ItemPriceNoTax, TotalPriceNoTax,
		ItemPriceCur, TotalPriceCur,
		CauseType, CauseID, CauseSpecItem, DisplayItem,
		nvl((select RL.AwaitQuantity
				from SMSpecRL RL
				where RL.DocType = SP.DocType
					and RL.DocID = SP.DocID
					and RL.SpecItem = SP.SpecItem), 0) as SuggestQuantity,
		Decode(nvl(ItemPrice, 0)+nvl(ItemPriceNoTax, 0)+nvl(ItemPriceCur,0), 0, 0, 1) as PriceExists
		from SMSpec SP
		where SP.DocType='OR'