DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on MTL_SYSTEM_ITEMS_VL

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