VIEW: APPS.ICX_CATALOG_AVAIL_ITEMS_V

Source

View Text - Preformatted

SELECT DISTINCT POL.ITEM_ID , POL.CREATION_DATE , ICX_UTIL.ITEM_FLEX_SEG(MSI.ROWID) ITEM_NUMBER , POL.ITEM_DESCRIPTION , POL.VENDOR_PRODUCT_NUM , POL.UNIT_PRICE , POL.LIST_PRICE_PER_UNIT , POL.UNIT_MEAS_LOOKUP_CODE , POL.MARKET_PRICE , POH.VENDOR_ID , POL.CATEGORY_ID FROM PO_HEADERS POH , PO_LINES POL , MTL_SYSTEM_ITEMS MSI WHERE MSI.INVENTORY_ITEM_ID > 0 AND POH.PO_HEADER_ID = POL.PO_HEADER_ID AND MSI.INVENTORY_ITEM_ID = POL.ITEM_ID AND ((POH.TYPE_LOOKUP_CODE = 'QUOTATION' AND POH.STATUS_LOOKUP_CODE = 'A') OR (POH.TYPE_LOOKUP_CODE = 'BLANKET' AND POH.APPROVED_FLAG = 'Y')) AND POL.ITEM_ID IS NOT NULL

View Text - HTML Formatted

SELECT DISTINCT POL.ITEM_ID
, POL.CREATION_DATE
, ICX_UTIL.ITEM_FLEX_SEG(MSI.ROWID) ITEM_NUMBER
, POL.ITEM_DESCRIPTION
, POL.VENDOR_PRODUCT_NUM
, POL.UNIT_PRICE
, POL.LIST_PRICE_PER_UNIT
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.MARKET_PRICE
, POH.VENDOR_ID
, POL.CATEGORY_ID
FROM PO_HEADERS POH
, PO_LINES POL
, MTL_SYSTEM_ITEMS MSI
WHERE MSI.INVENTORY_ITEM_ID > 0
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND MSI.INVENTORY_ITEM_ID = POL.ITEM_ID
AND ((POH.TYPE_LOOKUP_CODE = 'QUOTATION'
AND POH.STATUS_LOOKUP_CODE = 'A') OR (POH.TYPE_LOOKUP_CODE = 'BLANKET'
AND POH.APPROVED_FLAG = 'Y'))
AND POL.ITEM_ID IS NOT NULL