VIEW: APPS.MSC_X_ITEMS_LOV_V

Source

View Text - Preformatted

SELECT cm.inventory_item_id inventory_item_id, cm.item_name item_name, null channel_master_item, null customer_item, null supplier_item, cm.creation_date creation_date, cm.created_by created_by, cm.last_updated_by last_updated_by, cm.last_update_date last_update_date, cm.last_update_login last_update_login, cm.description from msc_items cm

View Text - HTML Formatted

SELECT CM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CM.ITEM_NAME ITEM_NAME
, NULL CHANNEL_MASTER_ITEM
, NULL CUSTOMER_ITEM
, NULL SUPPLIER_ITEM
, CM.CREATION_DATE CREATION_DATE
, CM.CREATED_BY CREATED_BY
, CM.LAST_UPDATED_BY LAST_UPDATED_BY
, CM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CM.DESCRIPTION
FROM MSC_ITEMS CM