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 253: From mtl_system_items_kfv

249:
250: --Bug#5436402 getting tracking_quantity_ind also
251: Cursor get_item_info is
252: Select inventory_item_id, tracking_quantity_ind
253: From mtl_system_items_kfv
254: Where concatenated_segments = p_item_no
255: and organization_id = g_organization_id;
256:
257: Cursor get_wip_info is

Line 957: from mtl_system_items_kfv

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

Line 2166: from mtl_system_items_kfv

2162: , p_organization_id IN NUMBER
2163: )
2164: is
2165: Select concatenated_segments
2166: from mtl_system_items_kfv
2167: Where inventory_item_id = p_item_id
2168: and organization_id = p_organization_id
2169: ;
2170: Begin

Line 2249: from mtl_system_items_kfv

2245: , p_organization_id IN NUMBER
2246: )
2247: is
2248: Select concatenated_segments
2249: from mtl_system_items_kfv
2250: Where inventory_item_id = p_item_id
2251: and organization_id = p_organization_id
2252: ;
2253: Begin