APPS.EAM_PROCESS_WO_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3272: FROM mtl_system_items_kfv msik

3268: l_other_token_tbl(1).token_name := 'Inventory_Item';
3269: -- l_other_token_tbl(1).token_value := l_eam_mat_req_rec.inventory_item_id ;
3270:
3271: SELECT concatenated_segments into l_token_tbl(1).token_value
3272: FROM mtl_system_items_kfv msik
3273: WHERE msik.inventory_item_id = l_eam_mat_req_rec.inventory_item_id
3274: AND msik.organization_id = l_eam_mat_req_rec.organization_id;
3275:
3276: RAISE EXC_SEV_SKIP_BRANCH ;

Line 11147: FROM mtl_system_items_kfv msi

11143: CLOSE cur_work_order_details;
11144:
11145: SELECT msi.concatenated_segments
11146: INTO l_asset_group_name
11147: FROM mtl_system_items_kfv msi
11148: WHERE msi.inventory_item_id = l_asset_group_id
11149: AND rownum = 1;
11150:
11151: Begin

Line 11154: FROM mtl_system_items_kfv msi

11150:
11151: Begin
11152: SELECT msi.concatenated_segments
11153: INTO l_asset_activity
11154: FROM mtl_system_items_kfv msi
11155: WHERE msi.inventory_item_id = l_asset_activity_id
11156: AND rownum = 1;
11157: Exception
11158: When NO_DATA_FOUND Then

Line 12322: FROM mtl_system_items_kfv msi

12318: AND wdj.wip_entity_id = ewod.wip_entity_id(+);
12319:
12320: SELECT msi.concatenated_segments
12321: INTO l_asset_group_name
12322: FROM mtl_system_items_kfv msi
12323: WHERE msi.inventory_item_id = l_asset_group_id
12324: AND rownum = 1;
12325: Begin
12326: SELECT msi.concatenated_segments

Line 12328: FROM mtl_system_items_kfv msi

12324: AND rownum = 1;
12325: Begin
12326: SELECT msi.concatenated_segments
12327: INTO l_asset_activity
12328: FROM mtl_system_items_kfv msi
12329: WHERE msi.inventory_item_id = l_asset_activity_id
12330: AND rownum = 1;
12331:
12332: Exception