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 989: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

985: select sitems.description description
986: into v_description
987: from mtl_system_items_vl sitems
988: where
989: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
990: and sitems.inventory_item_id = IID;
991:
992: /* srw.reference (:item_flex);
993: srw.reference (:p_item_flex_code);

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

1011: mtl_system_items_vl sitems
1012: where citems.customer_item_id = cxref.customer_item_id
1013: and cxref.inventory_item_id = sitems.inventory_item_id
1014: and citems.customer_item_id = ordered_item_id
1015: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1016: and sitems.inventory_item_id = IID;
1017: elsif (p_print_description in ('C','P','O')) then
1018: Begin
1019: select items.cross_reference item,

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

1025: where xtypes.cross_reference_type = items.cross_reference_type
1026: and items.inventory_item_id = sitems.inventory_item_id
1027: and items.cross_reference = ORDERED_ITEM
1028: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1029: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1030: and sitems.inventory_item_id = IID
1031: and items.org_independent_flag = 'N'
1032: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1033: Exception When NO_DATA_FOUND Then

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

1028: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1029: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1030: and sitems.inventory_item_id = IID
1031: and items.org_independent_flag = 'N'
1032: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1033: Exception When NO_DATA_FOUND Then
1034: Select items.cross_reference item,
1035: nvl(items.description,sitems.description) description
1036: into v_item,v_description

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

1040: where xtypes.cross_reference_type = items.cross_reference_type
1041: and items.inventory_item_id = sitems.inventory_item_id
1042: and items.cross_reference = ORDERED_ITEM
1043: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1044: and nvl(sitems.organization_id,0 ) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1045: and sitems.inventory_item_id = IID
1046: and items.org_independent_flag ='Y';
1047: End;
1048: --Bug 3433353 End