APPS.ONT_OEXPRPRD_XMLP_PKG dependencies on MO_GLOBAL

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

20: from mtl_system_items_vl sitems
21: where
22: sitems.customer_order_enabled_flag = 'Y' and
23: sitems.bom_item_type in (1,4)
24: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
25: and sitems.inventory_item_id = iid_L;
26: -- :rp_dummy_item := v_item;
27:
28: /* srw.reference (:ITEM_FLEX);

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

48: mtl_system_items_vl sitems
49: where citems.customer_item_id = cxref.customer_item_id
50: and cxref.inventory_item_id = sitems.inventory_item_id
51: and citems.customer_item_id = oid_L
52: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
53: and sitems.inventory_item_id = iid_L;
54: -- and sitems.customer_order_enabled_flag = 'Y'
55: -- and sitems.bom_item_type in (1,4)
56: elsif (p_print_description in ('C','P','O')) then

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

63: where xtypes.cross_reference_type = items.cross_reference_type
64: and items.inventory_item_id = sitems.inventory_item_id
65: and items.cross_reference = oi_L
66: and items.cross_reference_type = item_identifier_type_L
67: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
68: and sitems.inventory_item_id = iid_L;
69: -- and sitems.customer_order_enabled_flag = 'Y'
70: -- and sitems.bom_item_type in (1,4)
71: end if;

Line 99: P_ORGANIZATION_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;

95: ,'Failed in BEFORE REPORT trigger')*/NULL;
96: RETURN (FALSE);
97: END;
98: BEGIN
99: P_ORGANIZATION_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;
100: END;
101: DECLARE
102: L_COMPANY_NAME VARCHAR2(100);
103: L_FUNCTIONAL_CURRENCY VARCHAR2(15);

Line 845: IF Oe_Sys_Parameters.Value('RECURRING_CHARGES',mo_global.get_current_org_id())='Y' Then

841: RETURN RP_SELL_PRICE;
842: END RP_SELL_PRICE_P;
843: FUNCTION F_1FORMATTRIGGER RETURN VARCHAR2 IS
844: BEGIN
845: IF Oe_Sys_Parameters.Value('RECURRING_CHARGES',mo_global.get_current_org_id())='Y' Then
846: return ('TRUE');
847: ELSE
848: return ('FALSE');
849: END IF;