eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ONT_OEXOEOCS_XMLP_PKG dependencies on OE_SYS_PARAMETERS

Line 34: AND ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

30: MTL_SYSTEM_ITEMS_KFV
31: WHERE INVENTORY_ITEM_ID = P_ITEM
32: AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
33: AND BOM_ITEM_TYPE in ( 1 , 4 )
34: AND ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
35: END IF;
36: END;
37: DECLARE
38: L_COMPANY_NAME VARCHAR2(100);

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

223: from mtl_system_items_vl sitems
224: where
225: -- sitems.customer_order_enabled_flag = 'Y' --> Commented for the bug 2864636
226: -- and sitems.bom_item_type in (1,4)
227: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
228: and sitems.inventory_item_id = iid;
229: rp_dummy_item := v_item;
230: rp_dummy_item := '';
231: v_item := fnd_flex_xml_publisher_apis.process_kff_combination_1('Item_dsp', 'INV', p_item_flex_code, p_item_structure_num, C_ORGANIZATION_ID,C_INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE');

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

239: mtl_system_items_vl sitems
240: where citems.customer_item_id = cxref.customer_item_id
241: and cxref.inventory_item_id = sitems.inventory_item_id
242: and citems.customer_item_id = ordered_item_id
243: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
244: and sitems.inventory_item_id = iid;
245: -- and sitems.customer_order_enabled_flag = 'Y'
246: -- and sitems.bom_item_type in (1,4)
247: elsif (p_print_description in ('C','P','O')) then

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

255: where xtypes.cross_reference_type = items.cross_reference_type
256: and items.inventory_item_id = sitems.inventory_item_id
257: and items.cross_reference = ordered_item
258: and items.cross_reference_type = item_identifier_type
259: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
260: and sitems.inventory_item_id = iid
261: --Bug 3433353 Begin
262: and items.org_independent_flag = 'N'
263: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);

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

259: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
260: and sitems.inventory_item_id = iid
261: --Bug 3433353 Begin
262: and items.org_independent_flag = 'N'
263: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
264: -- and sitems.customer_order_enabled_flag = 'Y'
265: -- and sitems.bom_item_type in (1,4)
266: Exception When NO_DATA_FOUND Then
267: select items.cross_reference item,

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

275: and items.inventory_item_id =
276: sitems.inventory_item_id
277: and items.cross_reference = ordered_item
278: and items.cross_reference_type = item_identifier_type
279: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
280: and sitems.inventory_item_id = iid
281: and items.org_independent_flag = 'Y';
282: End;
283: