VIEW: APPS.ICX_CATALOG_ORD_ITEMS_V

Source

View Text - Preformatted

SELECT DISTINCT PRL.ITEM_ID , PRH.SEGMENT1 , PRL.REQUISITION_HEADER_ID , PRL.REQUISITION_LINE_ID , PRL.CATEGORY_ID , PRL.VENDOR_ID , PRL.CREATION_DATE , PRL.LINE_NUM , ICX_UTIL.ITEM_FLEX_SEG(MSI.ROWID) ITEM_NUMBER , PRL.ITEM_DESCRIPTION , PRL.UNIT_PRICE , PRL.QUANTITY , PRL.UNIT_MEAS_LOOKUP_CODE , PRL.UNIT_PRICE*PRL.QUANTITY EXT_AMOUNT FROM PO_REQUISITION_HEADERS PRH , PO_REQUISITION_LINES PRL , MTL_SYSTEM_ITEMS MSI WHERE MSI.INVENTORY_ITEM_ID > 0 AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID AND NVL(PRH.AUTHORIZATION_STATUS, 'APPROVE') != 'INCOMPLETE' AND NVL(PRH.CANCEL_FLAG,'N') != 'Y' AND PRL.ITEM_ID IS NOT NULL

View Text - HTML Formatted

SELECT DISTINCT PRL.ITEM_ID
, PRH.SEGMENT1
, PRL.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.CATEGORY_ID
, PRL.VENDOR_ID
, PRL.CREATION_DATE
, PRL.LINE_NUM
, ICX_UTIL.ITEM_FLEX_SEG(MSI.ROWID) ITEM_NUMBER
, PRL.ITEM_DESCRIPTION
, PRL.UNIT_PRICE
, PRL.QUANTITY
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.UNIT_PRICE*PRL.QUANTITY EXT_AMOUNT
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, MTL_SYSTEM_ITEMS MSI
WHERE MSI.INVENTORY_ITEM_ID > 0
AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID
AND NVL(PRH.AUTHORIZATION_STATUS
, 'APPROVE') != 'INCOMPLETE'
AND NVL(PRH.CANCEL_FLAG
, 'N') != 'Y'
AND PRL.ITEM_ID IS NOT NULL