VIEW: APPS.MSC_INVENTORY_LEVELS_V

Source

View Text - Preformatted

SELECT lvl.rowid, lvl.plan_id, item.item_name, item.description, lvl.inventory_date, item.UOM_code, lvl.target_quantity, lvl.target_quantity_dos, lvl.min_quantity, lvl.min_quantity_dos, lvl.max_quantity, lvl.max_quantity_dos, lvl.organization_id, lvl.sr_instance_id, lvl.inventory_item_id, lvl.LAST_UPDATE_DATE, lvl.LAST_UPDATED_BY , lvl.CREATION_DATE , lvl.CREATED_BY , lvl.LAST_UPDATE_LOGIN from msc_inventory_levels lvl, msc_system_items item WHERE lvl.organization_id = item.organization_id and lvl.sr_instance_id = item.sr_instance_id and lvl.inventory_item_id = item.inventory_item_id and lvl.plan_id = item.plan_id

View Text - HTML Formatted

SELECT LVL.ROWID
, LVL.PLAN_ID
, ITEM.ITEM_NAME
, ITEM.DESCRIPTION
, LVL.INVENTORY_DATE
, ITEM.UOM_CODE
, LVL.TARGET_QUANTITY
, LVL.TARGET_QUANTITY_DOS
, LVL.MIN_QUANTITY
, LVL.MIN_QUANTITY_DOS
, LVL.MAX_QUANTITY
, LVL.MAX_QUANTITY_DOS
, LVL.ORGANIZATION_ID
, LVL.SR_INSTANCE_ID
, LVL.INVENTORY_ITEM_ID
, LVL.LAST_UPDATE_DATE
, LVL.LAST_UPDATED_BY
, LVL.CREATION_DATE
, LVL.CREATED_BY
, LVL.LAST_UPDATE_LOGIN
FROM MSC_INVENTORY_LEVELS LVL
, MSC_SYSTEM_ITEMS ITEM
WHERE LVL.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND LVL.SR_INSTANCE_ID = ITEM.SR_INSTANCE_ID
AND LVL.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND LVL.PLAN_ID = ITEM.PLAN_ID