APPS.ONT_OEXOESOS_XMLP_PKG dependencies on OE_SYS_PARAMETERS

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

16: into v_item,v_description
17: from mtl_system_items_vl sitems
18: -- where sitems.customer_order_enabled_flag = 'Y'
19: -- and sitems.bom_item_type in (1,4)
20: where nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
21: and sitems.inventory_item_id = inventory_item_id_L;
22: /* srw.reference (:p_item_flex_code);
23: srw.reference (:Item_dsp);
24: srw.reference (:p_item_structure_num);

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

40: mtl_system_items_vl sitems
41: where citems.customer_item_id = cxref.customer_item_id
42: and cxref.inventory_item_id = sitems.inventory_item_id
43: and citems.customer_item_id = ordered_item_id_L
44: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
45: and sitems.inventory_item_id = inventory_item_id_L;
46: -- and sitems.customer_order_enabled_flag = 'Y'
47: -- and sitems.bom_item_type in (1,4)
48: elsif (p_print_description in ('C','P','O')) then

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

55: where xtypes.cross_reference_type = items.cross_reference_type
56: and items.inventory_item_id = sitems.inventory_item_id
57: and items.cross_reference = ordered_item_L
58: and items.cross_reference_type = item_identifier_type_L
59: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
60: and sitems.inventory_item_id = inventory_item_id_L;
61: -- and sitems.customer_order_enabled_flag = 'Y'
62: -- and sitems.bom_item_type in (1,4)
63: end if;

Line 1111: IF OE_SYS_PARAMETERS.VALUE ('RECURRING_CHARGES',MO_GLOBAL.GET_CURRENT_ORG_ID()) = 'Y' THEN

1107: END GET_DERIVE_TYPE;
1108:
1109: FUNCTION F_PERIODICITYFORMATTRIGGER RETURN VARCHAR2 IS
1110: BEGIN
1111: IF OE_SYS_PARAMETERS.VALUE ('RECURRING_CHARGES',MO_GLOBAL.GET_CURRENT_ORG_ID()) = 'Y' THEN
1112: RETURN ('TRUE');
1113: ELSE
1114: RETURN ('FALSE');
1115: END IF;