APPS.WSH_WV_UTILS dependencies on MTL_SYSTEM_ITEMS

Line 393: mtl_system_items msi

389: msi.volume_uom_code,
390: msi.unit_weight,
391: msi.unit_volume
392: FROM wsh_delivery_details wdd,
393: mtl_system_items msi
394: WHERE wdd.delivery_detail_id = v_delivery_detail_id
395: AND msi.inventory_item_id = wdd.inventory_item_id
396: AND msi.organization_id = wdd.organization_id;
397:

Line 3026: FROM mtl_system_items msi,

3022: nvl(msi.primary_uom_code,wdd.requested_quantity_uom), --Bug7165744
3023: nvl(wdd.received_quantity, nvl(wdd.shipped_quantity, NVL(wdd.picked_quantity, wdd.requested_quantity))),
3024: wdd.inventory_item_id
3025: ) qty
3026: FROM mtl_system_items msi,
3027: wsh_delivery_details wdd
3028: WHERE msi.inventory_item_id (+) = wdd.inventory_item_id
3029: AND msi.organization_id (+) = wdd.organization_id
3030: AND wdd.delivery_detail_id = p_deliveryDetailId;

Line 4598: FROM mtl_system_items

4594: x_return_status OUT NOCOPY VARCHAR2) IS
4595:
4596: CURSOR Get_Unit_Weight (v_cont_item_id NUMBER, v_org_id NUMBER) IS
4597: SELECT unit_weight, weight_uom_code
4598: FROM mtl_system_items
4599: WHERE inventory_item_id = v_cont_item_id
4600: AND organization_id = v_org_id;
4601:
4602: CURSOR Get_Cont_Info (v_cont_inst_id NUMBER) IS