APPS.WSM_RESERVATIONS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 251: from mtl_system_items

247: l_mtl_rsv_rec.expected_quantity := p_resulting_jobs_tbl(p_sj_also_rj_index).net_quantity;
248:
249: select primary_uom_code
250: into l_expected_quantity_uom --l_mtl_rsv_rec.expected_quantity_uom
251: from mtl_system_items
252: where inventory_item_id =l_mtl_rsv_rec.inventory_item_id-- p_starting_jobs_tbl(p_starting_jobs_tbl.first).primary_item_id
253: and organization_id = l_mtl_rsv_rec.organization_id; --p_starting_jobs_tbl(p_starting_jobs_tbl.first).organization_id;
254:
255:

Line 709: from mtl_system_items

705: l_mtl_rsv_rec.expected_quantity := p_net_qty;
706:
707: select primary_uom_code
708: into l_mtl_rsv_rec.expected_quantity_uom
709: from mtl_system_items
710: where inventory_item_id =l_mtl_rsv_rec.inventory_item_id
711: and organization_id = l_mtl_rsv_rec.organization_id;
712:
713: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1054: from mtl_system_items

1050: l_mtl_rsv_rec.expected_quantity := p_new_net_qty;
1051:
1052: select primary_uom_code
1053: into l_expected_quantity_uom --l_mtl_rsv_rec.expected_quantity_uom
1054: from mtl_system_items
1055: where inventory_item_id =l_mtl_rsv_rec.inventory_item_id
1056: and organization_id = l_mtl_rsv_rec.organization_id;
1057:
1058: