VIEW: APPS.CZ_SPARES_V

Source

View Text - Preformatted

SELECT EC.QUOTE_HDR_ID,EC.QUOTE_REV_NBR,SS.QTY AS SPARE_QTY,IM.REF_PART_NBR,QS.ITEM_QTY, QS.TYPE_FLAG,QS.QUOTED_LIST_PRICE,QS.PACKAGE_SEQ,IM.ORIG_SYS_REF,QS.ITEM_ID FROM CZ_QUOTE_HDRS EC, CZ_SPARES_SPECIALS SS, CZ_QUOTE_SPARES QS, CZ_ITEM_MASTERS IM WHERE EC.QUOTE_HDR_ID = SS.QUOTE_HDR_ID AND EC.QUOTE_REV_NBR = SS.QUOTE_REV_NBR AND SS.QUOTE_REV_NBR = QS.QUOTE_REV_NBR AND SS.QUOTE_HDR_ID = QS.QUOTE_HDR_ID AND QS.ITEM_ID = IM.ITEM_ID 

View Text - HTML Formatted

SELECT EC.QUOTE_HDR_ID
, EC.QUOTE_REV_NBR
, SS.QTY AS SPARE_QTY
, IM.REF_PART_NBR
, QS.ITEM_QTY
, QS.TYPE_FLAG
, QS.QUOTED_LIST_PRICE
, QS.PACKAGE_SEQ
, IM.ORIG_SYS_REF
, QS.ITEM_ID
FROM CZ_QUOTE_HDRS EC
, CZ_SPARES_SPECIALS SS
, CZ_QUOTE_SPARES QS
, CZ_ITEM_MASTERS IM
WHERE EC.QUOTE_HDR_ID = SS.QUOTE_HDR_ID
AND EC.QUOTE_REV_NBR = SS.QUOTE_REV_NBR
AND SS.QUOTE_REV_NBR = QS.QUOTE_REV_NBR
AND SS.QUOTE_HDR_ID = QS.QUOTE_HDR_ID
AND QS.ITEM_ID = IM.ITEM_ID