DBA Data[Home] [Help]

APPS.WSH_WV_UTILS dependencies on MTL_SYSTEM_ITEMS

Line 388: mtl_system_items msi

384: msi.volume_uom_code,
385: msi.unit_weight,
386: msi.unit_volume
387: FROM wsh_delivery_details wdd,
388: mtl_system_items msi
389: WHERE wdd.delivery_detail_id = v_delivery_detail_id
390: AND msi.inventory_item_id = wdd.inventory_item_id
391: AND msi.organization_id = wdd.organization_id;
392:

Line 3013: FROM mtl_system_items msi,

3009: nvl(msi.primary_uom_code,wdd.requested_quantity_uom), --Bug7165744
3010: nvl(wdd.received_quantity, nvl(wdd.shipped_quantity, NVL(wdd.picked_quantity, wdd.requested_quantity))),
3011: wdd.inventory_item_id
3012: ) qty
3013: FROM mtl_system_items msi,
3014: wsh_delivery_details wdd
3015: WHERE msi.inventory_item_id (+) = wdd.inventory_item_id
3016: AND msi.organization_id (+) = wdd.organization_id
3017: AND wdd.delivery_detail_id = p_deliveryDetailId;

Line 4585: FROM mtl_system_items

4581: x_return_status OUT NOCOPY VARCHAR2) IS
4582:
4583: CURSOR Get_Unit_Weight (v_cont_item_id NUMBER, v_org_id NUMBER) IS
4584: SELECT unit_weight, weight_uom_code
4585: FROM mtl_system_items
4586: WHERE inventory_item_id = v_cont_item_id
4587: AND organization_id = v_org_id;
4588:
4589: CURSOR Get_Cont_Info (v_cont_inst_id NUMBER) IS