SELECT ROWID, AUTO_SERIAL_ALPHA_PREFIX, NEW_REVISION_CODE, RESERVABLE_TYPE, SHIPPABLE_ITEM_FLAG, SO_TRANSACTIONS_FLAG, INVOICE_ENABLED_FLAG,
NEW_REVISION_CODE || '.' || RESERVABLE_TYPE || '.' || SHIPPABLE_ITEM_FLAG || '.' || SO_TRANSACTIONS_FLAG || '.' || INVOICE_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_B
SELECT ROWID
, AUTO_SERIAL_ALPHA_PREFIX
, NEW_REVISION_CODE
, RESERVABLE_TYPE
, SHIPPABLE_ITEM_FLAG
, SO_TRANSACTIONS_FLAG
, INVOICE_ENABLED_FLAG
,
NEW_REVISION_CODE || '.' || RESERVABLE_TYPE || '.' || SHIPPABLE_ITEM_FLAG || '.' || SO_TRANSACTIONS_FLAG || '.' || INVOICE_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_B
|
|
|