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

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

443:
444: FUNCTION C_MASTER_ORGFORMULA RETURN NUMBER IS
445: V_MASTER_ORG VARCHAR2(20);
446: BEGIN
447: V_MASTER_ORG := NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
448: ,MO_GLOBAL.GET_CURRENT_ORG_ID)
449: ,0);
450: RETURN V_MASTER_ORG;
451: END C_MASTER_ORGFORMULA;

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

737: from mtl_system_items_vl sitems
738: where
739: sitems.customer_order_enabled_flag = 'Y' and
740: sitems.bom_item_type in (1,4)
741: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
742: and sitems.inventory_item_id = inventory_item_id1;
743: 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');
744: elsif (item_identifier_type = 'CUST' and p_print_description in ('C','P','O')) then
745: select citems.customer_item_number item,

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

750: mtl_system_items_vl sitems
751: where citems.customer_item_id = cxref.customer_item_id
752: and cxref.inventory_item_id = sitems.inventory_item_id
753: and citems.customer_item_id = ordered_item_id
754: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
755: and sitems.inventory_item_id = inventory_item_id1;
756: -- and sitems.customer_order_enabled_flag = 'Y'
757: -- and sitems.bom_item_type in (1,4)
758: elsif (p_print_description in ('C','P','O')) then

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

766: where xtypes.cross_reference_type = items.cross_reference_type
767: and items.inventory_item_id = sitems.inventory_item_id
768: and items.cross_reference = ordered_item
769: and items.cross_reference_type = item_identifier_type
770: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
771: and sitems.inventory_item_id = inventory_item_id1
772: -- Bug 3433353 Begin
773: and items.org_independent_flag ='N'
774: and items.organization_id = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0);

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

770: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
771: and sitems.inventory_item_id = inventory_item_id1
772: -- Bug 3433353 Begin
773: and items.org_independent_flag ='N'
774: and items.organization_id = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0);
775: -- and sitems.customer_order_enabled_flag = 'Y'
776: -- and sitems.bom_item_type in (1,4)
777: Exception When NO_DATA_FOUND Then
778: select items.cross_reference item,

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

785: items.cross_reference_type
786: and items.inventory_item_id = sitems.inventory_item_id
787: and items.cross_reference = ordered_item
788: and items.cross_reference_type = item_identifier_type
789: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
790: and sitems.inventory_item_id = inventory_item_id1
791: and items.org_independent_flag = 'Y';
792: End;
793: --Bug 3433353 End