306: ELSE
307:
308: -- Get Master Organization
309:
310: G_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',g_org_id);
311:
312: -- Get Set of Books currency
313:
314: --added for moac to call Oe_sys_params only if org_id is not null
312: -- Get Set of Books currency
313:
314: --added for moac to call Oe_sys_params only if org_id is not null
315: IF G_org_id IS NOT NULL THEN
316: l_sob_id := oe_sys_parameters.value('SET_OF_BOOKS_ID',g_org_id);
317: ELSE
318: l_sob_id := null;
319: END IF;--if g_org_id
320:
355: WHERE ORG_ID = g_org_id;
356:
357: END IF;
358:
359: /* Fix for Bug# 1798953. Instead of using lines.org, used oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id) to use the master organization in get_uom_code and get_converted_qty functions */
360:
361: /* Fix for Bug# 3558790. Instead of using lines.pricing_quantity for calculating item amounts, used lines.ordered_quantity */
362: FOR i IN Cur_get_items
363: LOOP
386: request_id)
387: (SELECT lines.org_id,
388: lines.inventory_item_id,
389: lines.sold_to_org_id,
390: get_uom_code(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id)),
391: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd1,
392: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
393: lines.ordered_quantity,lines.order_quantity_uom),0)),
394: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd2,
388: lines.inventory_item_id,
389: lines.sold_to_org_id,
390: get_uom_code(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id)),
391: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd1,
392: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
393: lines.ordered_quantity,lines.order_quantity_uom),0)),
394: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd2,
395: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
396: lines.ordered_quantity,lines.order_quantity_uom),0)),
391: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd1,
392: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
393: lines.ordered_quantity,lines.order_quantity_uom),0)),
394: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd2,
395: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
396: lines.ordered_quantity,lines.order_quantity_uom),0)),
397: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd3,
398: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
399: lines.ordered_quantity,lines.order_quantity_uom),0)),
394: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd2,
395: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
396: lines.ordered_quantity,lines.order_quantity_uom),0)),
397: sum(get_value(hdrs.ordered_date,l_ordr_vol_perd3,
398: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),
399: lines.ordered_quantity,lines.order_quantity_uom),0)),
400: sum(decode(hdrs.transactional_curr_code,gsob.currency_code,
401: get_value(hdrs.ordered_date,l_ordr_vol_perd1,
402: lines.ordered_quantity*lines.unit_list_price,0),