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.INL_SHIPMENT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 10404: l_debug_info := 'Get Primary UOM Code from MTL_SYSTEM_ITEMS_VL';

10400: p_procedure_name => l_api_name,
10401: p_var_name => 'p_qty',
10402: p_var_value => p_qty) ;
10403:
10404: l_debug_info := 'Get Primary UOM Code from MTL_SYSTEM_ITEMS_VL';
10405: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
10406: p_procedure_name => l_api_name,
10407: p_debug_info => l_debug_info);
10408: SELECT msi.primary_uom_code

Line 10410: FROM mtl_system_items_vl msi

10406: p_procedure_name => l_api_name,
10407: p_debug_info => l_debug_info);
10408: SELECT msi.primary_uom_code
10409: INTO x_1ary_uom_code
10410: FROM mtl_system_items_vl msi
10411: WHERE msi.inventory_item_id = p_inventory_item_id
10412: AND msi.organization_id = p_organization_id;
10413:
10414: INL_LOGGING_PVT.Log_Variable (

Line 10581: l_debug_info := 'Get Secondary UOM Code from MTL_SYSTEM_ITEMS_VL';

10577: p_procedure_name => l_api_name,
10578: p_var_name => 'p_qty',
10579: p_var_value => p_qty) ;
10580:
10581: l_debug_info := 'Get Secondary UOM Code from MTL_SYSTEM_ITEMS_VL';
10582: INL_LOGGING_PVT.Log_Statement (
10583: p_module_name => g_module_name,
10584: p_procedure_name => l_api_name,
10585: p_debug_info => l_debug_info

Line 10590: FROM mtl_system_items_vl msi

10586: ) ;
10587:
10588: SELECT msi.secondary_uom_code
10589: INTO x_2ary_uom_code
10590: FROM mtl_system_items_vl msi
10591: WHERE msi.inventory_item_id = p_inventory_item_id
10592: AND msi.organization_id = p_organization_id;
10593:
10594: INL_LOGGING_PVT.Log_Variable (

Line 10853: FROM mtl_system_items_vl msi

10849: SELECT msi.primary_uom_code,
10850: msi.secondary_uom_code
10851: INTO x_1ary_uom_code,
10852: x_2ary_uom_code
10853: FROM mtl_system_items_vl msi
10854: WHERE msi.inventory_item_id = p_inventory_item_id
10855: AND msi.organization_id = p_organization_id;
10856: l_debug_info := 'Have gotten from mtl_system_items_vl:';
10857: INL_LOGGING_PVT.Log_Statement (

Line 10856: l_debug_info := 'Have gotten from mtl_system_items_vl:';

10852: x_2ary_uom_code
10853: FROM mtl_system_items_vl msi
10854: WHERE msi.inventory_item_id = p_inventory_item_id
10855: AND msi.organization_id = p_organization_id;
10856: l_debug_info := 'Have gotten from mtl_system_items_vl:';
10857: INL_LOGGING_PVT.Log_Statement (
10858: p_module_name => g_module_name,
10859: p_procedure_name => l_api_name,
10860: p_debug_info => l_debug_info

Line 13589: FROM mtl_system_items

13585: -- Get Lot Number for the item
13586: BEGIN
13587: SELECT start_auto_lot_number, segment1 -- Bug #15927464
13588: INTO l_lot_number, l_item -- Bug #15927464
13589: FROM mtl_system_items
13590: WHERE organization_id = p_organization_id
13591: AND inventory_item_id = p_inventory_item_id;
13592: EXCEPTION WHEN NO_DATA_FOUND THEN
13593: l_lot_number := NULL;

Line 13778: FROM mtl_system_items

13774: INTO l_tracking_quantity_ind,
13775: l_secondary_default_ind,
13776: l_ont_pricing_qty_source,
13777: l_lot_number
13778: FROM mtl_system_items
13779: WHERE organization_id = p_organization_id
13780: AND inventory_item_id = p_inventory_item_id;
13781:
13782: -- If Defaulting method is 'Fixed', 'Default' or 'No Default'