eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on OE_SYS_PARAMETERS

Line 310: G_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',g_org_id);

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

Line 316: l_sob_id := oe_sys_parameters.value('SET_OF_BOOKS_ID',g_org_id);

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:

Line 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 */

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

Line 390: get_uom_code(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id)),

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,

Line 392: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',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,
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)),

Line 395: get_converted_qty(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)),
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)),

Line 398: get_converted_qty(lines.inventory_item_id,oe_sys_parameters.value('MASTER_ORGANIZATION_ID',lines.org_id),

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),