DBA Data[Home] [Help]

VIEW: APPS.BOM_EXPLOSION_TEMP_DFV

Source

View Text - Preformatted

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
View Text - HTML Formatted

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