SELECT rt_category_id AS shopping_category_id, TO_NUMBER(external_source_key) AS po_category_id FROM icx_por_category_order_map WHERE external_source = 'Oracle'
View Text - HTML Formatted
SELECT RT_CATEGORY_ID AS SHOPPING_CATEGORY_ID , TO_NUMBER(EXTERNAL_SOURCE_KEY) AS PO_CATEGORY_ID FROM ICX_POR_CATEGORY_ORDER_MAP WHERE EXTERNAL_SOURCE = 'ORACLE'