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
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
|
|
|