DBA Data[Home] [Help]

VIEW: APPS.BOM_EXPLOSION_TEMP1_DFV

Source

View Text - Preformatted

SELECT ROWID, PRICING_CONTEXT, TOP_ALTERNATE_DESIGNATOR, TO_DATE(SORT_ORDER, 'YYYY/MM/DD HH24:MI:SS'), TOP_BILL_SEQUENCE_ID,  
 TOP_ALTERNATE_DESIGNATOR || '.' || SORT_ORDER || '.' || TOP_BILL_SEQUENCE_ID 
 FROM BOM_EXPLOSION_TEMP
View Text - HTML Formatted

SELECT ROWID
, PRICING_CONTEXT
, TOP_ALTERNATE_DESIGNATOR
, TO_DATE(SORT_ORDER
, 'YYYY/MM/DD HH24:MI:SS')
, TOP_BILL_SEQUENCE_ID
, TOP_ALTERNATE_DESIGNATOR || '.' || SORT_ORDER || '.' || TOP_BILL_SEQUENCE_ID
FROM BOM_EXPLOSION_TEMP