VIEW: APPS.CSP_ONHAND_PARTS_V

Source

View Text - Preformatted

SELECT mosv.organization_id, mosv.subinventory_code, mosv.locator_id, mosv.locator, mosv.inventory_item_id, mosv.revision, mosv.uom, mosv.on_hand, mosv.lot_number, mosv.serial_number from mtl_onhand_serial_v mosv union all select mollv.organization_id, mollv.subinventory_code, mollv.locator_id, milk.concatenated_segments locator, mollv.inventory_item_id, mollv.revision, mollv.primary_uom_code uom, mollv.total_qoh on_hand, mollv.lot lot_number, to_char(null) serial_number from mtl_onhand_locator_lot_v mollv, mtl_item_locations_kfv milk where mollv.item_serial_control = 1 and milk.organization_id (+) = mollv.organization_id and milk.inventory_location_id (+) = mollv.locator_id and milk.subinventory_code (+) = mollv.subinventory_code

View Text - HTML Formatted

SELECT MOSV.ORGANIZATION_ID
, MOSV.SUBINVENTORY_CODE
, MOSV.LOCATOR_ID
, MOSV.LOCATOR
, MOSV.INVENTORY_ITEM_ID
, MOSV.REVISION
, MOSV.UOM
, MOSV.ON_HAND
, MOSV.LOT_NUMBER
, MOSV.SERIAL_NUMBER
FROM MTL_ONHAND_SERIAL_V MOSV UNION ALL SELECT MOLLV.ORGANIZATION_ID
, MOLLV.SUBINVENTORY_CODE
, MOLLV.LOCATOR_ID
, MILK.CONCATENATED_SEGMENTS LOCATOR
, MOLLV.INVENTORY_ITEM_ID
, MOLLV.REVISION
, MOLLV.PRIMARY_UOM_CODE UOM
, MOLLV.TOTAL_QOH ON_HAND
, MOLLV.LOT LOT_NUMBER
, TO_CHAR(NULL) SERIAL_NUMBER
FROM MTL_ONHAND_LOCATOR_LOT_V MOLLV
, MTL_ITEM_LOCATIONS_KFV MILK
WHERE MOLLV.ITEM_SERIAL_CONTROL = 1
AND MILK.ORGANIZATION_ID (+) = MOLLV.ORGANIZATION_ID
AND MILK.INVENTORY_LOCATION_ID (+) = MOLLV.LOCATOR_ID
AND MILK.SUBINVENTORY_CODE (+) = MOLLV.SUBINVENTORY_CODE