APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_SYSTEM_ITEMS_KFV

Line 15: g_tracking_quantity_ind mtl_system_items_kfv.tracking_quantity_ind%type; --Bug#5436402

11: g_debug NUMBER;
12: g_inventory_item_id NUMBER;
13: g_organization_id NUMBER;
14: g_organization_desc VARCHAR2(240);
15: g_tracking_quantity_ind mtl_system_items_kfv.tracking_quantity_ind%type; --Bug#5436402
16: g_wip_entity_id NUMBER;
17: g_wip_entity_type NUMBER;
18: g_current_org_id NUMBER;
19: g_include_txns VARCHAR2(1);

Line 249: From mtl_system_items_kfv

245:
246: --Bug#5436402 getting tracking_quantity_ind also
247: Cursor get_item_info is
248: Select inventory_item_id, tracking_quantity_ind
249: From mtl_system_items_kfv
250: Where concatenated_segments = p_item_no
251: and organization_id = g_organization_id;
252:
253: Cursor get_wip_info is

Line 953: from mtl_system_items_kfv

949: , concatenated_segments
950: , description
951: , retest_interval
952: , DECODE(tracking_quantity_ind,'PS',secondary_uom_code) secondary_uom_code --Bug#5436402
953: from mtl_system_items_kfv
954: where inventory_item_id= p_item_info_rec.inventory_item_id
955: and organization_id = g_organization_id;
956: Begin
957: debug('write item info');

Line 2119: from mtl_system_items_kfv

2115: , p_organization_id IN NUMBER
2116: )
2117: is
2118: Select concatenated_segments
2119: from mtl_system_items_kfv
2120: Where inventory_item_id = p_item_id
2121: and organization_id = p_organization_id
2122: ;
2123: Begin

Line 2202: from mtl_system_items_kfv

2198: , p_organization_id IN NUMBER
2199: )
2200: is
2201: Select concatenated_segments
2202: from mtl_system_items_kfv
2203: Where inventory_item_id = p_item_id
2204: and organization_id = p_organization_id
2205: ;
2206: Begin