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

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

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

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

519:
520: FUNCTION C_MASTER_ORGFORMULA RETURN NUMBER IS
521: V_MASTER_ORG VARCHAR2(20);
522: BEGIN
523: V_MASTER_ORG := NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
524: ,MO_GLOBAL.GET_CURRENT_ORG_ID)
525: ,0);
526: RETURN V_MASTER_ORG;
527: END C_MASTER_ORGFORMULA;

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

582: into v_item,v_description
583: from mtl_system_items_vl sitems
584: -- where sitems.customer_order_enabled_flag = 'Y'
585: -- and sitems.bom_item_type in (1,4)
586: where nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
587: and sitems.inventory_item_id = inventory_item_id1;
588: 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');
589:
590: elsif (item_identifier_type = 'CUST' and p_print_description in ('C','P','O')) then

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

596: mtl_system_items_vl sitems
597: where citems.customer_item_id = cxref.customer_item_id
598: and cxref.inventory_item_id = sitems.inventory_item_id
599: and citems.customer_item_id = ordered_item_id
600: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
601: and sitems.inventory_item_id = inventory_item_id1;
602: -- and sitems.customer_order_enabled_flag = 'Y'
603: -- and sitems.bom_item_type in (1,4)
604: elsif (p_print_description in ('C','P','O')) then

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

612: where xtypes.cross_reference_type = items.cross_reference_type
613: and items.inventory_item_id = sitems.inventory_item_id
614: and items.cross_reference = ordered_item
615: and items.cross_reference_type = item_identifier_type
616: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
617: and sitems.inventory_item_id = inventory_item_id1
618: --Bug 3433353 Start
619: and items.org_independent_flag = 'N'
620: and items.organization_id = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0);

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

616: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
617: and sitems.inventory_item_id = inventory_item_id1
618: --Bug 3433353 Start
619: and items.org_independent_flag = 'N'
620: and items.organization_id = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0);
621: -- and sitems.customer_order_enabled_flag = 'Y'
622: -- and sitems.bom_item_type in (1,4)
623: Exception When NO_DATA_FOUND Then
624: Select items.cross_reference item,

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

632: and items.inventory_item_id =
633: sitems.inventory_item_id
634: and items.cross_reference = ordered_item
635: and items.cross_reference_type = item_identifier_type
636: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
637: and sitems.inventory_item_id = inventory_item_id1
638: and items.org_independent_flag = 'Y';
639: End;
640: --Bug 3433353 End