SELECT decode(rtrim(rt_category_id,'0123456789'),NULL,to_number(rt_category_id),-1) AS shopping_category_id, mcb.category_id AS po_category_id FROM icx_por_category_data_sources ipcds, mtl_categories_b mcb WHERE ipcds.external_source = 'Oracle' AND TO_CHAR(mcb.category_id) = external_source_key
SELECT DECODE(RTRIM(RT_CATEGORY_ID
, '0123456789')
, NULL
, TO_NUMBER(RT_CATEGORY_ID)
, -1) AS SHOPPING_CATEGORY_ID
, MCB.CATEGORY_ID AS PO_CATEGORY_ID
FROM ICX_POR_CATEGORY_DATA_SOURCES IPCDS
, MTL_CATEGORIES_B MCB
WHERE IPCDS.EXTERNAL_SOURCE = 'ORACLE'
AND TO_CHAR(MCB.CATEGORY_ID) = EXTERNAL_SOURCE_KEY
|
|
|