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

985: select sitems.description description
986: into v_description
987: from mtl_system_items_vl sitems
988: where
989: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
990: and sitems.inventory_item_id = IID;
991:
992: /* srw.reference (:item_flex);
993: srw.reference (:p_item_flex_code);

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

1011: mtl_system_items_vl sitems
1012: where citems.customer_item_id = cxref.customer_item_id
1013: and cxref.inventory_item_id = sitems.inventory_item_id
1014: and citems.customer_item_id = ordered_item_id
1015: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1016: and sitems.inventory_item_id = IID;
1017: elsif (p_print_description in ('C','P','O')) then
1018: Begin
1019: select items.cross_reference item,

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

1025: where xtypes.cross_reference_type = items.cross_reference_type
1026: and items.inventory_item_id = sitems.inventory_item_id
1027: and items.cross_reference = ORDERED_ITEM
1028: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1029: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1030: and sitems.inventory_item_id = IID
1031: and items.org_independent_flag = 'N'
1032: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1033: Exception When NO_DATA_FOUND Then

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

1028: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1029: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1030: and sitems.inventory_item_id = IID
1031: and items.org_independent_flag = 'N'
1032: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
1033: Exception When NO_DATA_FOUND Then
1034: Select items.cross_reference item,
1035: nvl(items.description,sitems.description) description
1036: into v_item,v_description

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

1040: where xtypes.cross_reference_type = items.cross_reference_type
1041: and items.inventory_item_id = sitems.inventory_item_id
1042: and items.cross_reference = ORDERED_ITEM
1043: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T
1044: and nvl(sitems.organization_id,0 ) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
1045: and sitems.inventory_item_id = IID
1046: and items.org_independent_flag ='Y';
1047: End;
1048: --Bug 3433353 End