APPS.CTO_UTILITY_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 4271: l_desc Mtl_system_items_kfv.description%type;

4267: start with line_id = p_line_id
4268: connect by link_to_line_id = prior line_id;
4269:
4270:
4271: l_desc Mtl_system_items_kfv.description%type;
4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4273: l_loop_switch Boolean := TRUE;
4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4275: l_model_ord_qty Number;

Line 4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;

4268: connect by link_to_line_id = prior line_id;
4269:
4270:
4271: l_desc Mtl_system_items_kfv.description%type;
4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4273: l_loop_switch Boolean := TRUE;
4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4275: l_model_ord_qty Number;
4276:

Line 4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;

4270:
4271: l_desc Mtl_system_items_kfv.description%type;
4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4273: l_loop_switch Boolean := TRUE;
4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4275: l_model_ord_qty Number;
4276:
4277:
4278: l_new_line varchar2(10) := fnd_global.newline;

Line 4402: from mtl_system_items_kfv msi

4398: msi.concatenated_segments
4399: into l_desc,
4400: l_prim_uom,
4401: l_item_name
4402: from mtl_system_items_kfv msi
4403: where msi.inventory_item_id = comp_cur.inventory_item_id
4404: and msi.organization_id = comp_cur.ship_from_org_id;
4405:
4406: --for text attachment

Line 7207: l_item_id mtl_system_items_kfv.inventory_item_id%type;

7203:
7204: --Bugfix 13554996: New variables
7205: l_conv_qty_lot_level number;
7206: l_conv_qty_item_level number;
7207: l_item_id mtl_system_items_kfv.inventory_item_id%type;
7208: l_order_uom_code oe_order_lines_all.order_quantity_uom%type;
7209:
7210: --This gets the reservation_qty and the type of reservation
7211: -- Modified by Renga Kannan on 06/24/05 for Cross Dock project