APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on MO_GLOBAL

Line 18: P_ORGANIZATION_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;

14: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
15: END;
16: END;
17: BEGIN
18: P_ORGANIZATION_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;
19: END;
20: BEGIN
21: IF P_ITEM IS NOT NULL THEN
22: SELECT

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

993: select sitems.description description
994: into v_description
995: from mtl_system_items_vl sitems
996: where
997: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
998: and sitems.inventory_item_id = IID;
999:
1000: /* srw.reference (:item_flex);
1001: srw.reference (:p_item_flex_code);

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

1019: mtl_system_items_vl sitems
1020: where citems.customer_item_id = cxref.customer_item_id
1021: and cxref.inventory_item_id = sitems.inventory_item_id
1022: and citems.customer_item_id = ordered_item_id
1023: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1024: and sitems.inventory_item_id = IID;
1025: elsif (p_print_description in ('C','P','O')) then
1026: Begin
1027: select items.cross_reference item,

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

1033: where xtypes.cross_reference_type = items.cross_reference_type
1034: and items.inventory_item_id = sitems.inventory_item_id
1035: and items.cross_reference = ORDERED_ITEM
1036: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1037: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1038: and sitems.inventory_item_id = IID
1039: and items.org_independent_flag = 'N'
1040: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1041: Exception When NO_DATA_FOUND Then

Line 1040: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);

1036: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1037: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1038: and sitems.inventory_item_id = IID
1039: and items.org_independent_flag = 'N'
1040: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1041: Exception When NO_DATA_FOUND Then
1042: Select items.cross_reference item,
1043: nvl(items.description,sitems.description) description
1044: into v_item,v_description

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

1048: where xtypes.cross_reference_type = items.cross_reference_type
1049: and items.inventory_item_id = sitems.inventory_item_id
1050: and items.cross_reference = ORDERED_ITEM
1051: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1052: and nvl(sitems.organization_id,0 ) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1053: and sitems.inventory_item_id = IID
1054: and items.org_independent_flag ='Y';
1055: End;
1056: --Bug 3433353 End