VIEW: APPS.POA_ITEMS_V

Source

View Text - Preformatted

SELECT pot.po_item_id id, eni.value value, eni.description description from poa_items pot, eni_item_v eni WHERE eni.inventory_item_id = pot.item_id and eni.organization_id = pot.organization_id UNION ALL select po_item_id id , vendor_product_num||' ('||vendor_name||')' value, description from poa_items_mv UNION ALL select pot.po_item_id id , pot.description || ' (' || cat.concatenated_segments || ')' value, pot.description description from poa_items pot, mtl_categories_kfv cat where pot.item_id is null and pot.vendor_product_Num is null and pot.category_id = cat.category_id

View Text - HTML Formatted

SELECT POT.PO_ITEM_ID ID
, ENI.VALUE VALUE
, ENI.DESCRIPTION DESCRIPTION
FROM POA_ITEMS POT
, ENI_ITEM_V ENI
WHERE ENI.INVENTORY_ITEM_ID = POT.ITEM_ID
AND ENI.ORGANIZATION_ID = POT.ORGANIZATION_ID UNION ALL SELECT PO_ITEM_ID ID
, VENDOR_PRODUCT_NUM||' ('||VENDOR_NAME||')' VALUE
, DESCRIPTION
FROM POA_ITEMS_MV UNION ALL SELECT POT.PO_ITEM_ID ID
, POT.DESCRIPTION || ' (' || CAT.CONCATENATED_SEGMENTS || ')' VALUE
, POT.DESCRIPTION DESCRIPTION
FROM POA_ITEMS POT
, MTL_CATEGORIES_KFV CAT
WHERE POT.ITEM_ID IS NULL
AND POT.VENDOR_PRODUCT_NUM IS NULL
AND POT.CATEGORY_ID = CAT.CATEGORY_ID