APPS.ONT_OEXCRDIS_XMLP_PKG dependencies on OE_SYS_PARAMETERS

Line 360: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

356: from mtl_system_items_vl sitems
357: where
358: sitems.customer_order_enabled_flag = 'Y' and
359: sitems.bom_item_type in (1,4)
360: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
361: and sitems.inventory_item_id = oe_inventory_item_id1;
362: -- rp_dummy_item := v_item;
363:
364: /* srw.reference (:ITEM_FLEX);

Line 388: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

384: mtl_system_items_vl sitems
385: where citems.customer_item_id = cxref.customer_item_id
386: and cxref.inventory_item_id = sitems.inventory_item_id
387: and citems.customer_item_id = ordered_item_id
388: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
389: and sitems.inventory_item_id = oe_inventory_item_id1;
390: -- and sitems.customer_order_enabled_flag = 'Y'
391: -- and sitems.bom_item_type in (1,4)
392: elsif (p_print_description in ('C','P','O')) then

Line 403: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

399: where xtypes.cross_reference_type = items.cross_reference_type
400: and items.inventory_item_id = sitems.inventory_item_id
401: and items.cross_reference = ordered_item
402: and items.cross_reference_type = item_identifier_type
403: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
404: and sitems.inventory_item_id = oe_inventory_item_id1;
405: -- and sitems.customer_order_enabled_flag = 'Y'
406: -- and sitems.bom_item_type in (1,4)
407: end if;