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_OEXOEORR_XMLP_PKG dependencies on OE_SYS_PARAMETERS

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

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

Line 224: V_MASTER_ORG := NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'

220:
221: FUNCTION C_MASTER_ORGFORMULA RETURN CHAR IS
222: V_MASTER_ORG VARCHAR2(20);
223: BEGIN
224: V_MASTER_ORG := NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
225: ,MO_GLOBAL.GET_CURRENT_ORG_ID)
226: ,0);
227: RETURN V_MASTER_ORG;
228: END C_MASTER_ORGFORMULA;

Line 332: where nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)

328: into v_item,v_description
329: from mtl_system_items_vl sitems
330: -- where sitems.customer_order_enabled_flag = 'Y'
331: -- and sitems.bom_item_type in (1,4)
332: where nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)
333: and sitems.inventory_item_id = inventory_item_id1;
334:
335: 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') ;
336: elsif (item_identifier_type = 'CUST' and p_print_description in ('C','P','O')) then

Line 346: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)

342: mtl_system_items_vl sitems
343: where citems.customer_item_id = cxref.customer_item_id
344: and cxref.inventory_item_id = sitems.inventory_item_id
345: and citems.customer_item_id = ordered_item_id
346: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)
347: and sitems.inventory_item_id = inventory_item_id1;
348: -- and sitems.customer_order_enabled_flag = 'Y'
349: -- and sitems.bom_item_type in (1,4)
350: elsif (p_print_description in ('C','P','O')) then

Line 362: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)

358: where xtypes.cross_reference_type = items.cross_reference_type
359: and items.inventory_item_id = sitems.inventory_item_id
360: and items.cross_reference = ordered_item
361: and items.cross_reference_type = item_identifier_type
362: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)
363: and sitems.inventory_item_id = inventory_item_id1
364: --Bug 3433353 Begin
365: and items.org_independent_flag = 'N'
366: and items.organization_id = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0);

Line 366: and items.organization_id = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0);

362: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)
363: and sitems.inventory_item_id = inventory_item_id1
364: --Bug 3433353 Begin
365: and items.org_independent_flag = 'N'
366: and items.organization_id = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0);
367: -- and sitems.customer_order_enabled_flag = 'Y'
368: -- and sitems.bom_item_type in (1,4)
369: Exception When NO_DATA_FOUND Then
370: Select items.cross_reference item, nvl(items.description,sitems.description) description

Line 380: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)

376: items.cross_reference_type
377: and items.inventory_item_id = sitems.inventory_item_id
378: and items.cross_reference = ordered_item
379: and items.cross_reference_type = item_identifier_type
380: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)
381: and sitems.inventory_item_id = inventory_item_id1
382: and items.org_independent_flag = 'Y';
383: End;
384: end if;