DBA Data[Home] [Help]

VIEW: APPS.MTL_SYSTEM_ITEMS_B3_DFV

Source

View Text - Preformatted

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

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