APPS.EAM_PROCESS_WO_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3293: FROM mtl_system_items_kfv msik

3289: l_other_token_tbl(1).token_name := 'Inventory_Item';
3290: -- l_other_token_tbl(1).token_value := l_eam_mat_req_rec.inventory_item_id ;
3291:
3292: SELECT concatenated_segments into l_token_tbl(1).token_value
3293: FROM mtl_system_items_kfv msik
3294: WHERE msik.inventory_item_id = l_eam_mat_req_rec.inventory_item_id
3295: AND msik.organization_id = l_eam_mat_req_rec.organization_id;
3296:
3297: RAISE EXC_SEV_SKIP_BRANCH ;

Line 11768: FROM mtl_system_items_kfv msi

11764: CLOSE cur_work_order_details;
11765:
11766: SELECT msi.concatenated_segments
11767: INTO l_asset_group_name
11768: FROM mtl_system_items_kfv msi
11769: WHERE msi.inventory_item_id = l_asset_group_id
11770: AND rownum = 1;
11771:
11772: Begin

Line 11775: FROM mtl_system_items_kfv msi

11771:
11772: Begin
11773: SELECT msi.concatenated_segments
11774: INTO l_asset_activity
11775: FROM mtl_system_items_kfv msi
11776: WHERE msi.inventory_item_id = l_asset_activity_id
11777: AND rownum = 1;
11778: Exception
11779: When NO_DATA_FOUND Then

Line 12992: FROM mtl_system_items_kfv msi

12988: AND wdj.wip_entity_id = ewod.wip_entity_id(+);
12989:
12990: SELECT msi.concatenated_segments
12991: INTO l_asset_group_name
12992: FROM mtl_system_items_kfv msi
12993: WHERE msi.inventory_item_id = l_asset_group_id
12994: AND rownum = 1;
12995: Begin
12996: SELECT msi.concatenated_segments

Line 12998: FROM mtl_system_items_kfv msi

12994: AND rownum = 1;
12995: Begin
12996: SELECT msi.concatenated_segments
12997: INTO l_asset_activity
12998: FROM mtl_system_items_kfv msi
12999: WHERE msi.inventory_item_id = l_asset_activity_id
13000: AND rownum = 1;
13001:
13002: Exception