SELECT ROWID, CONTEXT, PRIMARY_UOM_CODE, TO_DATE(PRIMARY_UNIT_OF_MEASURE, 'YYYY/MM/DD HH24:MI:SS'), GROUP_ID, SESSION_ID,
PRIMARY_UOM_CODE || '.' || PRIMARY_UNIT_OF_MEASURE || '.' || GROUP_ID || '.' || SESSION_ID
FROM BOM_EXPLOSION_TEMP
SELECT ROWID
, CONTEXT
, PRIMARY_UOM_CODE
, TO_DATE(PRIMARY_UNIT_OF_MEASURE
, 'YYYY/MM/DD HH24:MI:SS')
, GROUP_ID
, SESSION_ID
,
PRIMARY_UOM_CODE || '.' || PRIMARY_UNIT_OF_MEASURE || '.' || GROUP_ID || '.' || SESSION_ID
FROM BOM_EXPLOSION_TEMP
|
|
|