[Home] [Help]
View: ICX_CATALOG_SUMMARY_V
View Text
SELECT POV.VENDOR_ID
, PRL.CATEGORY_ID
, POV.SEGMENT1
, POV.VENDOR_NAME
, MCA.CONCATENATED_SEGMENTS
, ICX_GET.GET_AVAIL_ITEM_COUNT(POV.VENDOR_ID
, PRL.CATEGORY_ID)
, ICX_GET.GET_ORD_ITEM_COUNT(POV.VENDOR_ID
, 'ITEM_COUNT'
, PRL.CATEGORY_ID)
, ICX_GET.GET_ORD_ITEM_COUNT(POV.VENDOR_ID
, 'QUANTITY_SUM'
, PRL.CATEGORY_ID)
, ICX_GET.GET_ORD_ITEM_COUNT(POV.VENDOR_ID
, 'TOTAL_AMOUNT'
, PRL.CATEGORY_ID)
FROM PO_VENDORS POV
, MTL_CATEGORIES_KFV MCA
, PO_REQUISITION_LINES PRL
WHERE PRL.CATEGORY_ID > 0
AND (PRL.VENDOR_ID = POV.VENDOR_ID OR POV.VENDOR_NAME = PRL.SUGGESTED_VENDOR_NAME)
AND MCA.CATEGORY_ID = PRL.CATEGORY_ID GROUP BY POV.VENDOR_ID
, POV.SEGMENT1
, POV.VENDOR_NAME
, PRL.CATEGORY_ID
, MCA.CONCATENATED_SEGMENTS
Columns
Name |
VENDOR_ID |
CATEGORY_ID |
VENDOR_NUMBER |
VENDOR_NAME |
CATEGORY_CODE |
AVAILABLE_ITEMS |
ORDERED_ITEMS |
ORDERED_QUANTITY |
TOTAL_EXT_AMOUNT |