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

993: select sitems.description description
994: into v_description
995: from mtl_system_items_vl sitems
996: where
997: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
998: and sitems.inventory_item_id = IID;
999:
1000: /* srw.reference (:item_flex);
1001: srw.reference (:p_item_flex_code);

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

1019: mtl_system_items_vl sitems
1020: where citems.customer_item_id = cxref.customer_item_id
1021: and cxref.inventory_item_id = sitems.inventory_item_id
1022: and citems.customer_item_id = ordered_item_id
1023: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1024: and sitems.inventory_item_id = IID;
1025: elsif (p_print_description in ('C','P','O')) then
1026: Begin
1027: select items.cross_reference item,

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

1033: where xtypes.cross_reference_type = items.cross_reference_type
1034: and items.inventory_item_id = sitems.inventory_item_id
1035: and items.cross_reference = ORDERED_ITEM
1036: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1037: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1038: and sitems.inventory_item_id = IID
1039: and items.org_independent_flag = 'N'
1040: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1041: Exception When NO_DATA_FOUND Then

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

1036: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1037: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1038: and sitems.inventory_item_id = IID
1039: and items.org_independent_flag = 'N'
1040: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1041: Exception When NO_DATA_FOUND Then
1042: Select items.cross_reference item,
1043: nvl(items.description,sitems.description) description
1044: into v_item,v_description

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

1048: where xtypes.cross_reference_type = items.cross_reference_type
1049: and items.inventory_item_id = sitems.inventory_item_id
1050: and items.cross_reference = ORDERED_ITEM
1051: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1052: and nvl(sitems.organization_id,0 ) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1053: and sitems.inventory_item_id = IID
1054: and items.org_independent_flag ='Y';
1055: End;
1056: --Bug 3433353 End